NTSB investigations: Mooney M20J, WI
8 cases on aircraft the registry lists as Mooney M20J. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1981 | 1 |
| 2012 | 1 |
| 2016 | 2 |
| 2019 | 1 |
| 2024 | 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\" = 'WI' 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 ('5870219'))
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" = 'WI' 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 ('5870219'))
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 CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.NTSB CEN16FA295Accident · 1 fatalField investigationFinal reportMooney M20J · Holmen, WIThe pilot's loss of airplane control during an instrument approach. Contributing to the accident was the pilot's lack of instrument flight proficiency.NTSB GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB CEN12CA465Accident · Serious injuriesData collectionFinal reportMooney M20J · Oshkosh, WIThe pilot’s excessive airspeed at touchdown and his loss of control of the airplane during the landing roll.NTSB CHI81FA091Accident · 3 fatalClosedMooney M20J · La Pointe, WINTSB CHI80IEP10Accident · No injuriesClosedMooney M20J · Waterloo, WINTSB CHI79DEP08Accident · No injuriesClosedMooney M20J · Dodgeville, WI