NTSB investigations: Mooney M20, TX
12 cases on aircraft the registry lists as Mooney M20. 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 | 2 |
| 1967 | 2 |
| 1974 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1987 | 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 ('5870202'))
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 ('5870202'))
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 FTW87LA207Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Livingston, TXDrg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with…NTSB FTW85FPA03Accident · No injuriesFinal reportMooney M20 · Fort Worth, TXThe acft contacted an iron pole and a hangar following a loss of directional control during landing roll. The plt reported that after an aprx 300 ft ground roll, the acft veered left. The left wing contacted an iron pole which resulted in the acft rotating…NTSB FTW78DRG26Accident · No injuriesClosedMooney M20 · Smiley, TXNTSB FTW77FA064Accident · 1 fatalClosedMooney M20 · Shelbyville, TXNTSB FTW75DRG21Accident · No injuriesClosedMooney M20 · Bandera, TXNTSB FTW74DRG89Accident · No injuriesClosedMooney M20 · Falcon, TXNTSB FTW67F0512Accident · No injuriesClosedMooney M20 · League City, TXNTSB FTW67F0410Accident · No injuriesClosedMooney M-20 · El Paso, TXNTSB FTW67F0134Accident · No injuriesClosedMooney M20 · Austin, TXNTSB MKC66F0690Accident · No injuriesClosedMooney M20 · Big Sandy, TXNTSB UNK65X1213Accident · No injuriesClosedMooney M20 · Houston, TXNTSB UNK64X2377Accident · No injuriesClosedMooney MK20 · Wolfe City, TX