NTSB investigations: Mooney M20E, OH
11 cases on aircraft the registry lists as Mooney M20E. 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
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 2013 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'OH' 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 ('5870212'))
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" = 'OH' 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 ('5870212'))
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 CEN13CA190Accident · Serious injuriesData collectionFinal reportMooney M20E · Middletown, OHThe total loss of engine power due to fuel exhaustion, which resulted from the noncurrent pilot’s improper in-flight fuel management and decision-making and his decision to conduct the flight after consuming alcohol.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 CHI84LA109Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Cleveland, OHThe passenger reported that on takeoff he heard a bang & saw a puff of blue smoke. The plt pulled the pwr off but did not lower the nose so the passenger, who had flt experience, pushed the nose forward & impacted the rwy. Post crash examination of the eng…NTSB CHI76FEK31Accident · No injuriesClosedMooney M20E · Urbana, OHNTSB CHI76FEK07Accident · No injuriesClosedMooney M20E · Van Wert, OHNTSB CHI74FEG05Accident · Serious injuriesClosedMooney M20E · Harrison, OHNTSB CHI71FGA12Accident · No injuriesClosedMooney M20E · Cincinnati, OHNTSB CHI71AC074Accident · 4 fatalClosedMooney M20E · Willoughby, OHNTSB CHI67D0274Accident · No injuriesClosedMooney M21 · Cleveland, OHNTSB CHI67F0064Accident · No injuriesClosedMooney M20E · Saint Paris, OHNTSB CHI66A0030Accident · 4 fatalClosedMooney M20E · Painesville, OH