NTSB investigations: Mooney M20E, NM
14 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
| 1966 | 1 |
|---|---|
| 1967 | 2 |
| 1971 | 1 |
| 1977 | 2 |
| 1981 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 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\" = 'NM' 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" = 'NM' 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 CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…NTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB DEN00LA144Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMFuel exhaustion and the pilot's failure the refuel the airplane. Factors were the road signs.NTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.NTSB FTW98FA121Accident · 1 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot attempting VFR flight into instrument meteorological conditions and his lack of an instrument rating. Factors were weather conditions that included mountain wave activity conducive to turbulence, and clouds obscuring the mountainous terrain.NTSB DEN86FAMS3Accident · 2 fatalMissing aircraftFinal reportMooney M20F · Cuba, NMThe acft departed a private airstrip in Cuba, NM, for the purpose of viewing real estate property before continuing to taos. State authorities were notified the following day when the plt failed to arrive at work. A search for the acft was conducted until…NTSB DEN84LA109Accident · No injuriesLimited investigationFinal reportMooney M20E · Las Vegas, NMWhile enroute, the plt elected to land at Las Vegas, NM & check on his destination wx. He called the fss when the acft was about 30 mi south of Las Vegas & was advised that the wind at Las Vegas was from 230 deg at 20 KTS. He said he experienced severe…NTSB FTW81DQD20Accident · No injuriesClosedMooney M20C · Deming, NMNTSB DEN78F0A03Accident · No injuriesClosedMooney M20E · Clines Corners, NMNTSB DEN77FA051Accident · 2 fatalClosedMooney M20E · Albuquerque, NMNTSB DEN71FQA58Accident · Serious injuriesClosedMooney M20E · Albuquerque, NMNTSB DEN68D0037Accident · Serious injuriesClosedMooney M20E · Questa, NMNTSB DEN67F0262Accident · No injuriesClosedMooney M20E · Albuquerque, NMNTSB DEN67D0152Accident · No injuriesClosedMooney M20E · Lordsburg, NM