NTSB investigations: Mooney M20J
11 cases on aircraft the registry lists as Mooney M20J, where the first occurrence was “Hard landing”. 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
| 1985 | 1 |
|---|---|
| 1988 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870219')
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\" = 200))
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 ('5870219')
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" = 200))
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 LAX06CA297Accident · No injuriesData collectionFinal reportMooney M20J · Temecula, CAThe pilot's failure to flare that resulted in a hard landing.NTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…NTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.NTSB LAX01LA203Accident · No injuriesLimited investigationFinal reportMooney M20J · Jackson, CAFailure of the pilot to maintain proper airspeed for landing and airplane control with an existing crosswind. A contributing factor was the distraction of the pilot by a yelling passenger.NTSB ATL98LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Summerland Key, FLthe pilot's inadequate compensation for the wind conditions and failure to flare the airplane for landing. The gusty crosswind was a related factor.NTSB LAX97FA050Accident · 3 fatalField investigationFinal reportMooney M20J · Scottsdale, AZthe pilot misjudged the landing flare and failed to maintain directional control after a hard bounced landing.NTSB NYC95LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Belmar, NJThe student pilot's (1) misjudged flare (2) inadequate recovery from a bounced landing (3) failure to maintain directional control and the certified flight instructor's inadequate supervision.NTSB ATL94LA176Accident · No injuriesLimited investigationFinal reportMooney M20J · Chamblee, GAThe pilot's improper flare that resulted a in hard landing, followed by his improper recovery from a bounced landing, and his failure to maintain directional control during the attempted go- around.NTSB LAX93LA049Accident · No injuriesLimited investigationFinal reportMooney M20J · Santa Ana, CAThe pilot's improper landing flare, his improper bounced landing recovery technique, and his inadvertent entry into a stall mush condition.NTSB CHI88LA154Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Thief Rvr Falls, MNNTSB LAX85LA265Accident · No injuriesLimited investigationFinal reportMooney M20J · Rialto, CAAt the conclusion of a nearly 5 hours long non stop flight from NM to CA, the pilot attempted to land at an uncontroll-ed airport. The pilot acknowledged that the aircraft's finalapproach speed was excessive, and after the aircraft toucheddown it bounced off…