NTSB investigations: Mooney M20A, 1983
4 cases on aircraft the registry lists as Mooney M20A. 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 | 28 |
|---|---|
| 1965 | 25 |
| 1966 | 24 |
| 1967 | 17 |
| 1968 | 13 |
| 1969 | 8 |
| 1970 | 6 |
| 1971 | 10 |
| 1972 | 9 |
| 1973 | 16 |
| 1974 | 5 |
| 1975 | 7 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 2 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 3 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 1 |
| 2013 | 1 |
| 2019 | 1 |
| 2023 | 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 year(c.\"eventDate\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870204'))
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 year(c."eventDate") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870204'))
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 LAX84FA065Accident · 2 fatalField investigationFinal reportMooney M20A · Mammoth Lakes, CAThe acft crashed into a mountain side at some time prior to 0900 on 11/12/83 when the ELT signal was 1st reported, via satellite. Before the flt, the student plt was last seen in bakersfield, CA at about 0100 that morning. A rescue mission was delayed due to…NTSB LAX83LA410Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gila Bend, AZThe acft overran the rwy and collided with ditch during landing. The plt reported that the acft floated after the flare for landing and even though heavy braking was used after landing the acft did not stop on the rwy. The wind was calm but the plt said he…NTSB ATL83FA091Accident · 4 fatalField investigationFinal reportMooney M-20A · Prattville, ALThe left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…NTSB CHI83LA078Accident · No injuriesLimited investigationFinal reportMooney M20A · Ashkum, ILThe pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds…