NTSB investigations: Mooney M20E
15 cases on aircraft the registry lists as Mooney M20E, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1999 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest cases
Query with SQL
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\" = 250))
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" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA07FA218Accident · 2 fatalField investigationFinal reportMooney M20E · Tonasket, WAThe pilot's failure to maintain an adequate airspeed during initial climb following an aborted landing that resulted in a stall/spin. The pilot's misjudged speed and distance that resulted in a failure to attain a proper touchdown point was a factor.NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.NTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.NTSB ATL03LA088Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Milledgeville, GAThe pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.NTSB SEA02LA031Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Glasgow, MTThe pilot's failure to maintain adequate flying airspeed resulting in a stall/mush condition and loss of control at low altitude. A contributing factor was the pilot's distraction from flying the aircraft while attempting to retract the landing gear.NTSB LAX99FA275Accident · 2 fatalField investigationFinal reportMooney M20E · Las Vegas, NVThe pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.NTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.NTSB MIA94FA031Accident · 1 fatalField investigationFinal reportMooney M20E · Jacksonville, FLFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall. A factor related to the accident was: the lack of altitude for recovery from a stall.NTSB BFO92FA050Accident · 1 fatalField investigationFinal reportMooney M20E · Adamstown, MDFailure of the pilot to maintain control of the airplane.NTSB LAX91LA309Accident · 2 fatalLimited investigationFinal reportMooney M20 · Little River, CAThe pilot inadvertently inducing a stall spin condition with insufficient altitude to recover from the spin.NTSB FTW90LA128Accident · No injuriesLimited investigationFinal reportMooney M-20E · Luling, TXLoss of control in-flight due to the pilot's failure to maintain adequate airspeed. Factors would be the high density altitude and the tree that he hit.NTSB CHI90LA021Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Ravenna, OHThe pilot's failure to maintain aircraft control and airspeed which resulted in a stall. Factors related to the accident include the pilot overshooting the approach & landing due to misjudging his airspeed & distance, and a delayed go-around.NTSB DEN88LA076Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Miles City, MTNTSB DEN87FA186Accident · 2 fatalField investigationFinal reportMooney M20E · Vail, COThe pilot proceeded up a box canyon while on a cross-country flight. When unable to out climb terrain, the pilot attempted to reverse direction. During the turn, the aircraft stalled and crashed into trees. The pilot had not received instruction in mountain…NTSB FTW87FA021Accident · 1 fatalField investigationFinal reportMooney M20E · Arcola, TXThe plt departed Arcola, TX, VFR, on rwy 10, made a 180 degree left climbing turn and entered clouds at about the boundary line on the west side of the arpt. The radar operator stated the acft continued westbound one to two miles beyond the arpt then entered…