Skip to content

NTSB investigations: Mooney M20A, AZ

16 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('5870204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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 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 ('5870204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…Mar 28, 2013 · N6018X · Substantial damage NTSB LAX02LA009Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chandler, AZThe Bellanca pilot's failure to maintain directional control while taxiing due to his improper brake usage.Oct 21, 2001 · N2987Z · 2 aircraft · Minor damage NTSB LAX90LA197Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Apache Junction, AZFailure of the pilot in command to properly manage the aircraft fuel quantity gauge indication and failure to complete the proper emergency procedure by switching fuel tanks. Contributing to the accident was improper maintenance performed by the pilot which…May 28, 1990 · N8118E · Substantial damage NTSB LAX86LA121Accident · No injuriesLimited investigationFinal reportMooney MK-20 · Phoenix, AZA Mooney mk 20 collided with the runway surface after an engine failure. The engine failed on climb at about 1500 feet AGL and would not restart. The aircraft returned to the airport and landed downwind. The landing gear collapsed and the aircraft skidded off…Feb 20, 1986 · N8135E · Destroyed 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…Aug 26, 1983 · N6020X · Substantial damage 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…Dec 25, 1982 · N8130E · Destroyed NTSB LAX74FUJ22Accident · Serious injuriesClosedMooney M20A · Overgaard, AZSep 30, 1973 · N8163E · Destroyed NTSB LAX72DUJ47Accident · No injuriesClosedMooney M20A · Yuma, AZOct 5, 1971 · N6566B · Substantial damage NTSB LAX71FUJ91Accident · Minor injuriesClosedMooney M20A · Prescott, AZMay 14, 1971 · N8365E · Destroyed NTSB LAX70F0134Accident · No injuriesClosedMooney 20A · Goodyear, AZSep 10, 1969 · N1096B · Substantial damage NTSB LAX70D0109Accident · No injuriesClosedMooney M20A · Wenden, AZAug 28, 1969 · N8365E · Substantial damage NTSB LAX70F0001Accident · No injuriesClosedMooney M20A · Buckeye, AZMay 23, 1969 · N1078C · Substantial damage NTSB DEN66F0260Accident · No injuriesClosedMooney M20A · Yuma, AZMar 7, 1966 · N8140E · Substantial damage NTSB DEN65D0083Accident · No injuriesClosedMooney 20A · Safford, AZMay 11, 1965 · N8135E · Substantial damage NTSB UNK64X0881Accident · No injuriesClosedMooney M20 · Phoenix, AZMar 11, 1964 · N8377E · Substantial damage NTSB UNK64X0819Accident · No injuriesClosedMooney M20A · Tucson, AZMar 6, 1964 · N8361E · Substantial damage