NTSB investigations: Mooney M20B, 1982
3 cases on aircraft the registry lists as Mooney M20B. 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 | 12 |
|---|---|
| 1965 | 9 |
| 1966 | 9 |
| 1967 | 9 |
| 1968 | 5 |
| 1969 | 3 |
| 1970 | 3 |
| 1971 | 3 |
| 1972 | 4 |
| 1973 | 4 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 3 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 3 |
| 1993 | 2 |
| 1994 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2021 | 2 |
| 2022 | 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 ('5870206'))
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 ('5870206'))
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 NYC83FA035Accident · 2 fatalField investigationFinal reportMooney M20B · Auburn, NYDuring departure on an IFR climb-out radar and radio contact was lost. The pilot's last reported altitude was passing through 4,500 ft. the aircraft crashed into a wooded area at an elevation of 1,700 ft MSL. Initial contact was with trees approximately 40 ft…NTSB LAX82DA339Accident · Minor injuriesFinal reportMooney M20B · Scottsdale, AZThe plt reported he encountered a small amount of turbulence & a fairly strong crosswing on final. Touchdown was smooth & on the left side of the rwy. The acft then veered to the right. The plt saw a ditch ahead & applied full power before becoming airborne.…NTSB DEN82FA057Accident · 2 fatalField investigationFinal reportMooney M20B · Near Salida, COAfter departing Salida at approximately 0820 the plt radioed over UNICOM that the clouds in the local area had bases of 12,500 ft MSL & tops at 16,500 ft MSL. About 15 min later the acft impacted a mountain at the 13,500 ft level. There were flt precautions…