NTSB investigations: Mooney M20E

7 cases on aircraft the registry lists as Mooney M20E, where the first occurrence was “Loss of control - on ground/water”. 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

19822026

NTSB investigations: Mooney M20E per year, 1982–2026: 7 cases
1982	1
1983	1
1984	1
1992	1
1995	1
2002	1
2007	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870212')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 DFW07CA139Accident · No injuriesData collectionFinal reportMooney M-20E · Van, TXThe pilot's failure to maintain directional control during the takeoff run.Jun 19, 2007 · N115RC · Destroyed NTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…Nov 4, 2002 · N9288M · Substantial damage NTSB SEA95LA141Accident · No injuriesLimited investigationFinal reportMooney M20E · Ronan, MTDirectional control was not maintained. Factors to the accident were a rough/uneven airstrip and tall vegetation.Jun 29, 1995 · N9273M · Substantial damage NTSB BFO92LA148Accident · No injuriesLimited investigationFinal reportMooney M20E · Stow, MAFailure of the pilot to attain proper runway alignment during landing. Factors related to the accident were darkness, a lack of runway lighting on the left side of the runway, and the pilot's lack of visual ques.Sep 26, 1992 · N1338W · Substantial damage NTSB MIA84LA230Accident · Minor injuriesLimited investigationFinal reportMooney 20E · St. Simon, GAOn landing roll, acft swerved to left & departed rwy surface into grass. Plt applied full pwr and attempted go-around, headed aprx 20 degrees left of runway alignment. Acft became airborne, angling toward ramp and hangar complex. Witnessesobserved acft assume…Aug 15, 1984 · N6073Q · Substantial damage NTSB CHI83LA194Accident · No injuriesLimited investigationFinal reportMooney M20E · Springfield, ILThe acft ran off the left side of the rwy and collided with the VASI after landing. The plt stated he landed on rwy 22 when approach said the wind favored that rwy. He said that 'just as the wheels touched down a gust of wind pushed the nose to the left and…May 2, 1983 · N7430V · Substantial damage NTSB DEN82DA077Accident · No injuriesFinal reportMooney M20E · Hanksville, UTThe pilot stated that during the landing touchdown on runway 19, a gust of wind from about 270 degrees was encountered and the plane veered to the left. The pilot reported that he had applied corrective action, and the plane was tracking back to the runway,…May 1, 1982 · N6032Q · Substantial damage