NTSB investigations: Mooney M20, CA

12 cases on aircraft the registry lists as Mooney M20. 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

NTSB investigations: Mooney M20, CA per year, 1964–2026: 12 cases
1964	3
1966	1
1967	2
1971	1
1973	1
1977	1
1978	1
1997	1
2002	1

Where

Open the map

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 ('5870202')) 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 ('5870202'))
  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 ('5870202'))
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 LAX02LA271Accident · No injuriesLimited investigationFinal reportMooney M20 · Sierraville, CAthe pilot's decision to attempt takeoff in crosswind conditions that likely exceeded the capability of the airplane, and, his subsequent failure to maintain the airplane's proper alignment over the runway. Also causal was the pilot's premature liftoff and…Sep 2, 2002 · N881B · Substantial damage NTSB LAX98FA039Accident · 2 fatalField investigationFinal reportMooney M20 · Big Bear, CAVFR flight by the pilot into instrument meteorological conditions (VMC), which led to spatial disorientation, loss of aircraft control, and an uncontrolled descent into terrain. Related factors were: the adverse weather conditions, the pilot's lack of…Nov 15, 1997 · N5231B · Destroyed NTSB LAX78FA072Accident · 2 fatalClosedMooney M20 · Los Angeles, CAAug 30, 1978 · N864B · Destroyed NTSB LAX78FUD01Accident · Minor injuriesClosedMooney M20 · Compton, CAOct 29, 1977 · N4200 · Substantial damage NTSB LAX74AL041Accident · 3 fatalClosedMooney M-20 · Fillmore, CANov 24, 1973 · N5259B · Destroyed NTSB OAK72FXQ11Accident · Serious injuriesClosedMooney M-20 · Lee Vining, CAAug 22, 1971 · N886B · Substantial damage NTSB LAX68D0139Accident · No injuriesClosedMooney M20 · Santee, CAOct 1, 1967 · N887B · Substantial damage NTSB LAX68D0008Accident · No injuriesClosedMooney M20 · Santee, CAJun 12, 1967 · N887B · Substantial damage NTSB OAK66D0216Accident · No injuriesClosedMooney M20 · Palo Alto, CAMar 4, 1966 · N860B · Substantial damage NTSB UNK64X3548Accident · 1 fatalClosedMooney MK-20 · Seigler Spgs, CAAug 22, 1964 · N5241B · Destroyed NTSB UNK64X1291Accident · 3 fatalClosedMooney M20 · Beckwourth, CAApr 12, 1964 · N870B · Destroyed NTSB UNK64X0874Accident · No injuriesClosedMooney M20 · Laverne, CAMar 10, 1964 · N852B · Substantial damage