NTSB investigations: Mooney M20C
8 cases on aircraft the registry lists as Mooney M20C, 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
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2001 | 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\" = 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 ('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" = 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 LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.NTSB MIA01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20C · Jacksonville, FLThe failure of maintenance personnel to properly reconnect the aircraft's elevator control system, resulting in an in-flight disconnection of the elevator control and jamming of the rudder control during climb, the subsequent in-flight loss of control, and…NTSB CHI98LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · St Charles, MOfailure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.NTSB ATL98LA005Accident · No injuriesLimited investigationFinal reportMooney M20C · Hendersonville, NCThe undetermined malfunction of the nose gear steering assembly that resulted in the loss of directional control during a full stop landing. A factor was the rough and uneven runway condition. .NTSB SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.NTSB MIA85LA164Accident · No injuriesLimited investigationFinal reportMooney M20C · Bainbridge, GAWhile en route, the plt noted a severe eng vibration. He shut down the eng & made an emergency landing. During the roll-out, the acft hit a ditch & was damaged. An investigation revealed that one prop blade had failed from fatigue & the end of the blade had…NTSB FTW84LA293Accident · No injuriesLimited investigationFinal reportMooney M20C · Marshall, TXThe plt reported initial landing extension indicated an unsafe condition. The landing gear was recycled & a safe down & locked position was indicated. On landing roll the acft veered left off of the rwy & collided with trees. Tire marks on the rwy indicated…NTSB CHI84FA153Accident · 1 fatalField investigationFinal reportMooney M20C · Gary, INVFR plt received 2 wx briefings, filed an IFR flt plan and departed in night IFR conditions. Aprx 1 min after contacting chicago ARTCC plt reported he was having 'problems.' Aprx 1 min later plt reported, 'nine nine victor, I'm breaking up.' Acft wreckage was…