NTSB investigations: Mooney M20C, IN
12 cases on aircraft the registry lists as Mooney M20C. 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 | 1 |
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 2011 | 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.\"eventStateOrRegion\" = 'IN' 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 ('5870208'))
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" = 'IN' 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 ('5870208'))
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 CEN11LA636Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kokomo, INThe loss of engine power following takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CHI86FA077Accident · 2 fatalField investigationFinal reportMooney M20C · Loogootee, INPlt experienced loss of pwr during cruise flt at 6,000 feet. ATC vectored acft toward daviess county arpt, approximately 10 miles away. Plt reported acft on fire. Witnesses saw N9307V in a left bank turn then 'nose dive into ground.' Post crash exam of engine…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…NTSB CHI78FA059Accident · 2 fatalClosedMooney M20C · Valparaiso, INNTSB UNK76X0101Accident · No injuriesClosedMooney M20C · Hobart, INNTSB CHI72FEA04Accident · Minor injuriesClosedMooney M-20C · Watson, INNTSB CHI71AC078Accident · 2 fatalClosedMooney M20C · Muncie, INNTSB CHI71DBA25Accident · No injuriesClosedMooney M20C · Shelbyville, INNTSB CHI69F0149Accident · No injuriesClosedMooney M20C · Connersville, INNTSB CHI66D0637Accident · No injuriesClosedMooney M20C · Warsaw, INNTSB CHI66F0057Accident · No injuriesClosedMooney M20C · Indianapolis, INNTSB UNK65X0531Accident · No injuriesClosedMooney 20C · Indianapolis, IN