NTSB investigations: Mooney M20F
9 cases on aircraft the registry lists as Mooney M20F, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1985 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1999 | 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.\"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\" = 130))
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" = 130))
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 CHI99LA243Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marshall, MNthe inadvertent stall and the checklist not followed by the pilot. Contributing factors were the baggage door not secured and the precautionary landing attempt by the pilot.NTSB MIA99LA191Accident · No injuriesLimited investigationFinal reportMooney M20F · Liberty, NCImproper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…NTSB NYC91LA219Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Meadville, PAEngine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.NTSB ATL91FA020Accident · 2 fatalField investigationFinal reportMooney M20F · Pageland, SCFailure of the pilot to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the weather conditions and the malfunction of a gyro instrument (probably the attitude indicator).NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB ATL89LA064Accident · No injuriesLimited investigationFinal reportMooney M20F · Perdido, ALWhile descending to 6000 feet the pilot experienced a complete loss of engine oil supply. The windscreen was covered with oil and the pilot had to use the side window to gain forward visibility. After completing the emergency landing check the engine seized.…NTSB ATL87LA247Accident · No injuriesLimited investigationFinal reportMooney M20F · Put In Bay, OHThe plt heard a loud 'snap' while taxiing to the rwy, and the ldg gear collapsed immediately thereafter. The plt observed that the gear handle was still in the down-and-locked position and that the green 'gear down' light remained illuminated. FAA exam of the…NTSB SEA87LA128Accident · No injuriesLimited investigationFinal reportMooney M20F · Grants Pass, ORShortly after takeoff the pilot realized that he had no airspeed indication due to his forgetting to remove the pitot cover during preflight. The pilot returned to land at the airport and landed gear up.NTSB BFO85FA041Accident · No injuriesField investigationFinal reportMooney M20F · Stevensville, MDThe plt stated that when in normal curise at 3000 ft over castle marina arpt he noticed excessive oil and cylinder head temps. A concurrent small amount of smoke was emanating from the instrument panel which prompted the plt to execute a precautionary lndg at…