NTSB investigations: Mooney M20D, CA
14 cases on aircraft the registry lists as Mooney M20D. 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
| 1964 | 1 |
|---|---|
| 1965 | 4 |
| 1968 | 3 |
| 1980 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2007 | 2 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870210'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870210'))
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 SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.NTSB LAX07CA098Accident · No injuriesData collectionFinal reportMooney M20D · Visalia, CAThe pilot's inadequate in-flight fuel system management, which resulted in fuel starvation and a loss of engine power.NTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…NTSB LAX99FA294Accident · 1 fatalField investigationFinal reportMooney M20D · Bear Valley, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB LAX91LA135Accident · No injuriesLimited investigationFinal reportMooney M20D · Herlong, CAThe inadequate preparation of the propeller during overhaul. The installation of an improper pitched propeller and the fatigue failure of the propeller blade emanating from corrosion were factors in the accident.NTSB LAX80FA130Accident · 2 fatalClosedMooney M20C · Elk, CANTSB LAX69F0017Accident · No injuriesClosedMooney M21 · Yorba Linda, CANTSB OAK68D0376Accident · No injuriesClosedMooney M20D · Santa Rosa, CANTSB LAX68D0346Accident · No injuriesClosedMooney M20D · Riverside, CANTSB OAK66D0122Accident · No injuriesClosedMooney M20D · Auburn, CANTSB LAX66D0077Accident · No injuriesClosedMooney M20D · Riverside, CANTSB OAK66D0069Accident · No injuriesClosedMooney M20D · Auburn, CANTSB LAX66D0013Accident · No injuriesClosedMooney M21 · Mojave, CANTSB UNK65X0166Accident · Minor injuriesClosedMooney M20D · Yuba City, CA