NTSB investigations: Mooney M20F, NY
13 cases on aircraft the registry lists as Mooney M20F. 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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1996 | 2 |
| 2010 | 1 |
| 2014 | 1 |
| 2022 | 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\" = 'NY' 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 ('5870214'))
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" = 'NY' 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 ('5870214'))
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 ERA22LA307Accident · No injuriesClass 3 · LimitedFinal reportMooney M20F · Cragsmoor, NYThe pilot’s decision to continue toward rising terrain despite observing the airplane’s decreased climb performance after takeoff, which resulted in flight into terrain.NTSB ERA14FA345Accident · 3 fatalField investigationFinal reportMooney M20F · North Elba, NYThe pilot’s failure to maintain adequate airspeed for the airplane’s configuration and flight profile, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA11FA055Accident · 2 fatalField investigationFinal reportMooney M20F · Copake, NYThe pilot's failure to monitor and maintain clearance from mountainous terrain during a visual descent to the destination airport at night, which resulted in controlled flight into terrain.NTSB IAD97LA031Accident · 2 fatalLimited investigationFinal reportMooney M20F · Wellsville, NYDescent below the published minimum descent altitude followed by collision with the surrounding terrain.NTSB NYC96LA186Accident · No injuriesLimited investigationFinal reportMooney M20K · Islip, NYloss of engine power for undetermined reason(s), which resulted in an emergency/wheels-up landing.NTSB BFO92LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Johnstown, NYThe pilot misjudged altitude and distance which resulted in a landing undershood. Contributing to the accident was night conditions.NTSB NYC86LA097Accident · No injuriesLimited investigationFinal reportMooney M20 · Lockport, NYThe cross country flight was departing runway 28 at Lockport, new york in strong quartering wind conditions. At rotation and climb out, the pilot retracted the gears and flps. However as the aircraft flps retracted the aircraft began to drop. The nose was…NTSB NYC83LA038Accident · Minor injuriesLimited investigationFinal reportMooney M20F · North Caldwell, NYThe pilot stated that he encountered a fog bank while making a straight in landing at essex county airport. The pilot attempted to climb and still maintain visual contact with the ground, however the aircraft collided with a tree.NTSB NYC76FHJ31Accident · No injuriesClosedMooney M20F · White Plains, NYNTSB NYC74DFA35Accident · No injuriesClosedMooney M20F · Deposit, NYNTSB NYC72FHM52Accident · Serious injuriesClosedMooney M20F · Spring Valley, NYNTSB NYC72AN054Accident · 2 fatalClosedMooney M20F · Akron, NYNTSB NYC69F0041Accident · No injuriesClosedMooney M20F · Deer Park, NY