Skip to content

NTSB investigations: Mooney M20A, CA

24 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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 LAX06CA050Accident · Minor injuriesData collectionFinal reportMooney M20A · China Lake, CAfuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.Dec 2, 2005 · N6004X · Substantial damage NTSB LAX85LA334Accident · No injuriesLimited investigationFinal reportMooney M20A · Compton, CAThe student plt had a total of 36 flight hrs which included 9.4 hrs in the monney acft. He had been authorized by his CFI, who flew with him the preceding day, to practice landing. On the student's first attempted ldg, he touched down hard & began porpoising.…Jul 20, 1985 · N8141E · Substantial damage NTSB LAX84FA065Accident · 2 fatalField investigationFinal reportMooney M20A · Mammoth Lakes, CAThe acft crashed into a mountain side at some time prior to 0900 on 11/12/83 when the ELT signal was 1st reported, via satellite. Before the flt, the student plt was last seen in bakersfield, CA at about 0100 that morning. A rescue mission was delayed due to…Nov 12, 1983 · N8110E · Destroyed NTSB LAX80FUG35Accident · Serious injuriesClosedMooney M20A · Redlands, CAMay 23, 1980 · N6022X · Substantial damage NTSB OAK78FVD33Accident · Minor injuriesClosedMooney M20A · Santa Rosa, CAMay 2, 1978 · N8110E · Substantial damage NTSB OAK77DVD16Accident · No injuriesClosedMooney M20A · Hayward, CAFeb 10, 1977 · N6551B · Substantial damage NTSB LAX76AL092Accident · 2 fatalClosedMooney M20A · Lancaster, CAAug 24, 1976 · N1096B · Destroyed NTSB OAK76AP035Accident · 5 fatalClosedMooney M20A · Stockton, CADec 28, 1975 · N8120E · Destroyed NTSB LAX75DUM12Accident · Minor injuriesClosedMooney M20A · Oceanside, CANov 22, 1974 · N8198D · Substantial damage NTSB LAX74AL068Accident · 4 fatalClosedMooney M20A · San Frnando, CAApr 5, 1974 · N6552B · Destroyed NTSB OAK72DVG42Accident · No injuriesClosedMooney M-20A · Middletown, CAMar 18, 1972 · N8361E · Substantial damage NTSB LAX71FUM22Accident · Serious injuriesClosedMooney M20A · Brawley, CAJan 17, 1971 · N6012X · Substantial damage NTSB LAX68D0072Accident · No injuriesClosedMooney M21 · Laverne, CAJun 28, 1967 · N8130E · Substantial damage NTSB LAX67F0407Accident · No injuriesClosedMooney M20A · Long Beach, CAMay 6, 1967 · N8113E · Substantial damage NTSB LAX67D0158Accident · No injuriesClosedMooney M20A · Santa Susana, CAAug 30, 1966 · N8338E · Substantial damage NTSB OAK67D0082Accident · No injuriesClosedMooney MK20A · Kyburz, CAAug 15, 1966 · N1051B · Substantial damage NTSB OAK66D0304Accident · No injuriesClosedMooney M20A · Ukiah, CAMay 5, 1966 · N1061B · Substantial damage NTSB OAK66A0034Accident · 3 fatalClosedMooney MK-20A · Eureka, CAFeb 22, 1966 · N1067C · Destroyed NTSB OAK66F0179Accident · No injuriesClosedMooney 20A · Hayward, CADec 31, 1965 · N6552B · Substantial damage NTSB OAK66D0049Accident · No injuriesClosedMooney M20A · Hyampon, CAJun 22, 1965 · N8169E · Substantial damage NTSB UNK64X3260Accident · Minor injuriesClosedMooney MK20A · Linden, CAAug 7, 1964 · N6551B · Substantial damage NTSB UNK64X2741Accident · 3 fatalClosedMooney MK-20B · San Clemente, CAJul 9, 1964 · N78904 · Destroyed NTSB UNK64X2399Accident · No injuriesClosedMooney MK20A · Truckee, CAJun 20, 1964 · N8114E · Substantial damage NTSB UNK64X0134Accident · No injuriesClosedMooney 20A · Carlsbad, CAJan 3, 1964 · N8328E · Substantial damage