NTSB investigations: Mooney M22
11 cases on aircraft the registry lists as Mooney M22. 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
| 1967 | 2 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1975 | 2 |
| 1982 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 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 ('5870402'))
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 ('5870402'))
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 LAX90LA063Accident · No injuriesLimited investigationFinal reportMooney Mark 22 · Apple Valley, CAThe failure of the pilot of the Mooney to stop his aircraft in a timely manner to avoid a collision.NTSB MIA89LA205Accident · No injuriesLimited investigationFinal reportMooney M22 · Vero Beach, FLFailure of an old weld repair on the nose gear strut housing. A contributing factor was improper maintenance by other (unknown) maintenance personnel.NTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…NTSB ATL83FKG04Accident · No injuriesFinal reportMooney M22 · Hampton, GAAfter takeoff the acft climbed to about 60-70 ft & the eng quit. The acft crash landed off the end of rwy 24. The overboard flexible atmospheric drain vent, connected to the fuel pressurization valve, was found to be plugged by a very small piece of foreign…NTSB OAK76AP031Accident · 2 fatalClosedMooney M22 · Davis, CANTSB FTW75FRD60Accident · Minor injuriesClosedMooney M22 · New Orleans, LANTSB FTW74FPM10Accident · Serious injuriesClosedMooney M22 · Sand Springs, OKNTSB MIA72FLA28Accident · No injuriesClosedMooney M-22 · Bell, FLNTSB CHI71DEE85Accident · No injuriesClosedMooney M22 · Crestwood, ILNTSB FTW68F0407Accident · Serious injuriesClosedMooney M-22 · Kerrville, TXNTSB NYC68F0197Accident · No injuriesClosedMooney M-22 · Lititz, PA