NTSB investigations: Mooney M20A, 1982
5 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\") = 1982
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") = 1982
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 LAX83FA060Accident · Serious injuriesField investigationFinal reportMooney M20A · Gila Bend, AZWhile en route, the plt landed at Gila Bend with a generator problem. While on the ground for appoximately 2 hrs, the plt flashed the generator field & was able to obtain a positive ammeter reading. He then took off downwind & crashed immediately after…NTSB MKC83FCQ01Accident · Serious injuriesFinal reportMooney M20A · Halstead, KSDuring arrival, the pilot noted that the wind was from the northwest. He estimate it was from 330 deg at 20, gusting 35 KTS. On final approach, the aircraft was reportedly unstable due to gusty winds and turbulence. The pilot observed and was aware of the…NTSB FTW82FPD17Accident · Serious injuriesFinal reportMooney M20 · Abilene, TXAt about 50-75 ft AGL after takeoff the eng quit. Both tanks contained adequate fuel & no eng malfunctions were found.NTSB SEA82DA097Accident · Minor injuriesFinal reportMooney M20A · Twin Falls, IDDuring his preflight inspection, the pilot noted that the right fuel tank was partially full, but the left tank was nearly empty. The left tank was serviced with 12 gallons of fuel, but the pilot reported that the fuel selector was inadvertently left in the…NTSB FTW82FRG28Accident · Serious injuriesFinal reportMooney M20A · San Antonio, TXDuring arrival, the pilot entered the traffic pattern for a landing on runway 30 with a 7 knot tailwind. On final approach, he was not satisfied with his pattern and elected to go-around. During the go-around and climb, a map and checklist fell into the…