NTSB investigations: Warner SS40&50

7 cases on aircraft whose registry engine model is Warner SS40&50, where the first occurrence was “Loss of control - on ground/water”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations: Warner SS40&50 per year, 1984–2026: 7 cases
1984	1
1985	1
1989	1
1991	1
1995	1
1999	1
2004	1

Where

Open the map

Latest cases

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64503') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64503')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('64503')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW04LA102Accident · No injuriesLimited investigationFinal reportWaco RBA · Temple, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the locked wheel.Apr 3, 2004 · N12444 · Substantial damage NTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.Feb 14, 1999 · N10730 · Substantial damage NTSB CHI96LA001Accident · No injuriesLimited investigationFinal reportLuscombe Phantom 1 · Rolla, MOmechanical failure of the left brake.Oct 1, 1995 · N272Y · Substantial damage NTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.Mar 19, 1991 · N17687 · Substantial damage NTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.Nov 5, 1989 · N19464 · Substantial damage NTSB LAX85LA302Accident · No injuriesLimited investigationFinal reportMeyers OTW · Winters, CAThe purpose of this flt was to check out a commercial plt in the acft. Dual flt controls & heel brakes were installed. The student was practicing landings & on his 4th or 5th landing roll, the acft began to turn to the right. The student applied left rudder &…Jul 2, 1985 · N23799 · Substantial damage NTSB SEA84LA160Accident · Minor injuriesLimited investigationFinal reportRearwin Rearwin 8125 · The Dalles, ORThe plt inadvertantly taxied the acft to the wrong rwy for takeoff. The plt did say he saw acft departing from another rwy. Takeoff was attempted with a 19 kt x-wind. The acft ran off the side of the rwy before becoming airborne. The arpt manager has since…Jul 4, 1984 · N25547 · Substantial damage