NTSB investigations: Mooney M20F
10 cases on aircraft the registry lists as Mooney M20F, where the first occurrence was “In flight collision with terrain/water”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 230))
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" = 230))
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 NYC08CA067Accident · No injuriesData collectionFinal reportMooney M20F · Carrollton, GAThe pilot's descent below the glidepath during the approach, which resulted in a collision with terrain. Contributing factors included the pilot's diverted attention, pilot fatigue, and the night lighting conditions.NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.NTSB FTW90LA112Accident · No injuriesLimited investigationFinal reportMooney M-20F · Aledo, TXInadequate preflight planning/preparation, in as much as the performance data was not used by the pilot in command. Factors were the high density altitude, inadequate airspeed, and premature liftoff.NTSB DEN87FA167Accident · 1 fatalField investigationFinal reportMooney M20F · Mitchell, SDThis non-licensed plt made an unauthorized flt at night. The acft crashed one half mile north of the arpt. The occupant of the acft was fatally injured. No records of the plt's flt experience was found.NTSB BFO86FA050Accident · 1 fatalField investigationFinal reportMooney M20F · Leesburg, VADrg arrival, the plt was clrd for a VOR rwy 35 apch. Also, he was advised that there were problems with the rwy lights &that other plts had made missed apchs that evening due to dim arpt lighting. He was then clrd to UNICOM freq & told to cancel his IFR clnc…NTSB NYC86LA186Accident · Minor injuriesLimited investigationFinal reportMooney M20F · West Milford, NJDrg the landing roll, the plt believed there was insufficient braking, so he initiated a go-around. He rprtd that on climb-out, the tail of the acft impacted a 'hill.' The acft then crashed nose down & was destroyed. No preimpact part failure or malfunction…NTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…NTSB ATL83LA030Accident · No injuriesLimited investigationFinal reportMooney M20F · Talladega, ALPilot forgot to extend landing gear.NTSB CHI82DA204Accident · No injuriesFinal reportMooney M20F · Plainwell, MIThe pilot reported that when he entered the traffic pattern, the radios did not work. He stated that he had his mind on this problem and did not put the gear down. Also, he reported that on downwind, the gear warning horn did not work, and subsequently, the…