NTSB investigations: Mooney M20F
11 cases on aircraft the registry lists as Mooney M20F, 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 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 ('5870214')
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 ('5870214')
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 NYC06IA036Incident · No injuriesIncident investigationFinal reportMooney M20F · Cadiz, KYFuel starvation, which resulted in a loss of engine power.NTSB DFW05LA033Accident · No injuriesLimited investigationFinal reportMooney M20F · Fabens, TXThe loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL04FA061Accident · 1 fatalField investigationFinal reportMooney 20F · Campobello, SCThe pilot's failure to maintain airspeed while maneuvering for an emergency landing resulting in an inadvertent stall and a collision with trees and the ground during an uncontrolled descent. A factor in the accident was the pilot's inadequate preflight…NTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.NTSB LAX99LA035Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Upland, CALoss of engine power due to water contaminated fuel and the pilot's inadequate preflight inspection of the airplane. A factor was the failure of the owner/pilot to properly maintain the airplane.NTSB MIA98LA227Accident · No injuriesLimited investigationFinal reportMooney M-20F · Rockhill, SCThe pilot's inadequate fuel management which led to fuel exhaustion.NTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.NTSB LAX89FA133Accident · 4 fatalField investigationFinal reportMooney M20F · San Andreas, CAInterruption of engine power for an undetermined reason, and failue of the pilot to maintain airspeed, which resulted in a stall/spin. A factor related to the accident was: lack of altitude to recover from the stall/spin.NTSB ATL88FA174Accident · 4 fatalField investigationFinal reportMooney M20F · Middlesboro, KYWitnesses rprted the eng did not sound like it was providing full power drg takeoff & that abt 3/4 of the 3600' rwy was used for the takeoff roll. After lift-off, the acft climbed at a shallow angle to abt 250 to 300 ft AGL. It then entereda shallow left…NTSB SEA83LA195Accident · No injuriesLimited investigationFinal reportMooney M20-F · Seattle, WAThe plt stated he experienced a complete power loss while flying over puget sound at 700 ft. the acft sank & was not recovered.NTSB SEA82DA039Accident · Minor injuriesFinal reportMooney M20F · Maupin, ORThe pilot reported that the engine lost power during takeoff after he raised the gear and flaps. He stated that he lowered the nose and the stall warning buzzer sounded, but he was unable to obtain the necessary airspeed. He stated that the power began to…