NTSB investigations: Mooney M20D, TX
11 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 | 3 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1978 | 1 |
| 1986 | 1 |
| 1999 | 1 |
| 2008 | 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\" = 'TX' 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" = 'TX' 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 DFW08CA230AccidentData collectionFinal reportMooney M20D · Grand Saline, TXA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB FTW99LA254Accident · No injuriesLimited investigationFinal reportMooney M20D · Edna, TXFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.NTSB FTW87LA024Accident · Serious injuriesLimited investigationFinal reportMooney M20D · Kerrville, TXThe pilot was unable to extend the landing gear in preparation for landing. Troubleshooting and several attempts to extend the gear failed. The pilot then made a 360 degree turn over the airport to lose altitude during which, he secured the engine and stopped…NTSB FTW79DQG01Accident · No injuriesClosedMooney M20D · Borger, TXNTSB FTW69A0065Accident · 2 fatalClosedMooney M20D · Ft Stockton, TXNTSB FTW69D0332Accident · Minor injuriesClosedMooney M20D · Roaring Sprgs, TXNTSB FTW68D0166Accident · No injuriesClosedMooney M20D · San Angelo, TXNTSB FTW66F0358Accident · No injuriesClosedMooney M20D · Amarillo, TXNTSB UNK64X3261Accident · Serious injuriesClosedMooney M20D · Fort Worth, TXNTSB UNK64X3223Accident · No injuriesClosedMooney MK20D · Amarillo, TXNTSB UNK64X2390Accident · No injuriesClosedMooney M20D · Houston, TX