Skip to content

NTSB investigations: Mooney M20C, AZ

32 cases on aircraft the registry lists as Mooney M20C. 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 ('5870208')) 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 ('5870208'))
  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 ('5870208'))
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 CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…Dec 8, 2019 · N5557Q · Destroyed NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.Aug 7, 2005 · N6330Q · Substantial damage NTSB LAX04CA118Accident · No injuriesData collectionFinal reportMooney M20C · Mesa, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a collision with an airport sign.Feb 7, 2004 · N9675M · Substantial damage NTSB LAX01LA226Accident · No injuriesLimited investigationFinal reportMooney M20C · Tucson, AZThe airplane's collision with a perimeter roadway vehicular traffic sign due to the pilot's diverted attention and inadequate visual lookout while taxiing from landing. A contributing factor was the lack of sign conspicuity.Jun 28, 2001 · N311X · Substantial damage NTSB LAX96LA268Accident · No injuriesLimited investigationFinal reportMooney M20C · Payson, AZanimals on the runway. A factor was the dark night.Jul 8, 1996 · N6715N · Substantial damage NTSB LAX94LA202Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Page, AZThe failure of the pilots to assure that ample fuel would be available to reach the airport. The generator failure and an inoperative fuel quantity gage were contributing factors.Apr 23, 1994 · N6524U · Substantial damage NTSB LAX88FA042Accident · 4 fatalField investigationFinal reportMooney M20C · Grand Canyon, AZWhile cruising en route all engine power was suddenly lost and the plt attempted an emergency ldg at the Grand Canyon arpt. During the glide, the acft crashed into an outcrop of rocks on a steep cliff, 0.5 mi from the end of the rwy. Exam of the engine…Nov 15, 1987 · N6670R · Destroyed NTSB LAX86LA137Accident · Serious injuriesLimited investigationFinal reportMooney M-20C · Roll, AZThe plt landed at gila bend municipal arpt for fuel. The refueling facilities were closed and the decision was made to proceed to yuma int'l arpt, about 113 miles east of gila bend arpt. The plt had flown the acft for about 4 hrs and 5 minutes prior to…Mar 10, 1986 · N9694M · Substantial damage NTSB LAX84LA190Accident · No injuriesLimited investigationFinal reportMooney M20C · Scottsdale, AZThe plt reported that he failed to extend the landing gear prior to touchdown. Subsequently, the acft was damaged during a wheels up landing.Feb 21, 1984 · N6518U · Substantial damage NTSB LAX81FUJ04Accident · No injuriesClosedMooney M20C · Willcox, AZOct 16, 1980 · N9350V · Substantial damage NTSB LAX79FUJ14Accident · Minor injuriesClosedMooney M20C · Scottsdale, AZNov 13, 1978 · N1346W · Substantial damage NTSB LAX77FA002Accident · 2 fatalClosedMooney M20C · Phoenix, AZOct 9, 1976 · N2734W · Destroyed NTSB LAX76DUJ46Accident · No injuriesClosedMooney M20C · Camp Verde, AZOct 29, 1975 · N9661M · Substantial damage NTSB LAX76DUJ44Accident · No injuriesClosedMooney M20C · Holbrook, AZJul 15, 1975 · N6998U · Substantial damage NTSB LAX74AL012Accident · 1 fatalClosedMooney M-20C · Roosevlt Lk, AZAug 8, 1973 · N1390W · Destroyed NTSB LAX73DUJ63Accident · No injuriesClosedMooney MK-20 · Grand Canyn, AZMar 25, 1973 · N9184V · Substantial damage NTSB LAX73AL056Accident · 2 fatalClosedMooney M20C · Globe, AZMar 22, 1973 · N6675R · Destroyed NTSB LAX73DUJ18Accident · No injuriesClosedMooney M20 · Tucson, AZAug 17, 1972 · N7875V · Substantial damage NTSB LAX72FUJ80Accident · Serious injuriesClosedMooney M20C · Phoenix, AZMar 1, 1972 · N6204U · Destroyed NTSB LAX70D0235Accident · No injuriesClosedMooney M-20C · Winslow, AZDec 23, 1969 · N6746U · Substantial damage NTSB LAX70D0149Accident · Minor injuriesClosedMooney M-20C · Fort Grant, AZSep 23, 1969 · N9153V · Substantial damage NTSB LAX69D0003Accident · No injuriesClosedMooney M20C · Fort Thomas, AZJun 1, 1968 · N78886 · Substantial damage NTSB LAX68D0289Accident · No injuriesClosedMooney M20C · Phoenix, AZJan 27, 1968 · N6691U · Substantial damage NTSB LAX68D0176Accident · No injuriesClosedMooney M21 · Grand Canyon, AZOct 15, 1967 · N6691U · Substantial damage NTSB LAX68F0127Accident · No injuriesClosedMooney M21 · Showlow, AZAug 30, 1967 · N2637W · Substantial damage NTSB LAX68A0008Accident · 3 fatalClosedMooney M20C · Flagstaff, AZJul 17, 1967 · N6956U · Destroyed NTSB LAX67D0075Accident · No injuriesClosedMooney M20C · Flagstaff, AZAug 12, 1966 · N6511U · Substantial damage NTSB LAX67A0002Accident · 4 fatalClosedMooney M20C · Lake Havasu, AZJul 6, 1966 · N5907Q · Destroyed NTSB DEN66F0199Accident · No injuriesClosedMooney M20C · Phoenix, AZDec 29, 1965 · N7815V · Substantial damage NTSB DEN66D0161Accident · No injuriesClosedMooney M20C · Mormon Lake, AZOct 20, 1965 · N6758U · Substantial damage NTSB DEN65D0094Accident · No injuriesClosedMooney M21 · Lukachukai, AZApr 30, 1965 · N1354W · Substantial damage NTSB UNK64X3902Accident · Minor injuriesClosedMooney M20C · Sells, AZSep 10, 1964 · N6276U · Substantial damage