NTSB investigations: Mooney M20C
12 cases on aircraft the registry lists as Mooney M20C, where the first occurrence was “Loss of engine power”. 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.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.aircraft_model_code IN ('5870208')
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\" = 350))
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.aircraft_model_code IN ('5870208')
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" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA06LA057Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Cottage Grove, ORFuel starvation while on approach for landing resulting in a loss of engine power, and an inadequately accomplished annual inspection. Incorrect hardware which impeded the movement of the fuel selector valve, improper fuel management and not identifying the…NTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.NTSB ATL02FA026Accident · 1 fatalField investigationFinal reportMooney M20C · Gainesville, GAThe loss of engine power due to fuel starvation, resulting from fuel system blockage and improper maintenance by maintenance personnel. A factor was the unsuitable terrain.NTSB NYC00LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Reading, PAThe failure of the number two connecting rod after an improper overhaul by maintenance personnel.NTSB SEA97LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Bountiful, UTThe pilot's inadequate fuel management which resulted in fuel starvation.NTSB CHI94LA245Accident · No injuriesLimited investigationFinal reportMooney M20C · Macon, MOthe student pilot's decision to land on a closed runway under construction. A factor associated with the accident is the partial loss of engine power for an undetermined reason.NTSB MIA90LA040Accident · No injuriesLimited investigationFinal reportMooney M20 · Fort Lauderdale, FLPartial loss of engine power for an unknown reason.NTSB MKC88LA140Accident · No injuriesLimited investigationFinal reportMooney M20C · Olathe, KSShortly after takeoff, the pilot said the engine failed. He said he pumped the throttle and the engine restarted about the same time the acft returned to the runway. The engine restart propelled the aft back into the air. The plt felt he had sufficient power…NTSB NYC87LA219Accident · No injuriesLimited investigationFinal reportMooney M20C · Mclean, NYThe aircraft had flown for about 1-1/2 hours when the pilot began a descent from 12000 feet for an approach. However at 3500 feet, the engine suddenly went from normal cruise to idle. An emergency landing was made in a corn field and the aircraft was…NTSB ATL86FA222Accident · Serious injuriesField investigationFinal reportMooney M20C · Hillsville, VAThe plt, also an A&P and IA, had flown the acft on the previous day and noted RPM at 2500 on initial climb. On the accident flt, the acft was loaded to near max gross weight and takeoff was attempted at a density alt of 4810 ft MSL. The acft used about 3/4 of…NTSB MIA84LA259Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bimini, BahamasThe plt reported that he had been airborne for about 30 min when eng missed one time and stopped running. He attempted to switch fuel tanks but the selector only went to the off position and stuck. The plt ditched about 20 mi nw of Bimini island.NTSB MKC83LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Wheatland, MOThe pilot said the engine lost power after takeoff and settled into trees off the end of the rwy. The engine, damaged by fire, was examined and there was no evidence of pre-impact failures or deficiencies.