NTSB investigations: Mooney M20E, AZ
17 cases on aircraft the registry lists as Mooney M20E. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1990 | 1 |
| 2017 | 1 |
| 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 c.\"eventStateOrRegion\" = 'AZ' 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 ('5870212'))
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" = 'AZ' 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 ('5870212'))
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 WPR23LA023Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Marble Canyon, AZThe pilot’s loss of directional control during a takeoff from a rough, narrow runway, resulting in an aborted takeoff and subsequent runway excursion.NTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.NTSB LAX91LA033Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Tuba City, AZFailure of the piston rings which reduced the available engine power, and the pilot's continued operation of his airplane with a known engine deficiency during the relatively high density altitude conditions.NTSB LAX82DUJ19Accident · No injuriesClosedMooney M20E · Chandler, AZNTSB LAX80DUJ70Accident · No injuriesClosedMooney M20E · Holbrook, AZNTSB LAX78FA059Accident · 3 fatalClosedMooney M20E · Ajo, AZNTSB LAX75DUJ83Accident · Serious injuriesClosedMooney M20E · Coolidge, AZNTSB LAX73AL042Accident · 2 fatalClosedMooney M20E · Phoenix, AZNTSB LAX73AL026Accident · 1 fatalClosedMooney M20E · Apache Jctn, AZNTSB LAX72DUJ60Accident · No injuriesClosedMooney M20E · Keam Canyon, AZNTSB LAX70FUJ41Accident · No injuriesClosedMooney M20E · Tucson, AZNTSB LAX69D0229Accident · No injuriesClosedMooney M20E · Mesa, AZNTSB LAX67D0277Accident · No injuriesClosedMooney M20E · Showlow, AZNTSB LAX67F0169Accident · No injuriesClosedMooney M20E · Tucson, AZNTSB DEN66D0030Accident · No injuriesClosedMooney M20E · Heber, AZNTSB UNK65X1119Accident · 2 fatalClosedMooney M20E · Show Low, AZNTSB UNK64X4118Accident · Minor injuriesClosedMooney MK21 · Springervill, AZ