NTSB investigations: Mooney M20E, GA
11 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 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 'GA' 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" = 'GA' 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 ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB ATL03LA088Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Milledgeville, GAThe pilot's failure to maintain airspeed during climbout which resulted in a low altitude stall and subsequent in-flight collision with the terrain.NTSB ATL88LA188Accident · No injuriesLimited investigationFinal reportMooney M-20 · Hartwell, GAThe nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…NTSB MIA84LA230Accident · Minor injuriesLimited investigationFinal reportMooney 20E · St. Simon, GAOn landing roll, acft swerved to left & departed rwy surface into grass. Plt applied full pwr and attempted go-around, headed aprx 20 degrees left of runway alignment. Acft became airborne, angling toward ramp and hangar complex. Witnessesobserved acft assume…NTSB ATL83IA188Incident · No injuriesIncident investigationFinal reportMooney M20E · Hinesville, GAThe pilot failed to lower landing gear. The subsequent landing was executed non-intentional gear up. The pilot stated that she was preoccupied with a noise in the vicinity of the door.NTSB ATL82DA007Accident · No injuriesClosedCessna 340 · Waycross, GANTSB MIA76FKG29Accident · No injuriesClosedMooney M20E · Valdosta, GANTSB MIA75FKG02Accident · No injuriesClosedMooney M20C · Vidalia, GANTSB MIA70FKG45Accident · No injuriesClosedMooney M20E · Stone Mountain, GANTSB MIA67F0440Accident · Serious injuriesClosedMooney M20E · Chatsworth, GANTSB MIA66A0085Accident · 1 fatalClosedMooney M-20E · Manor, GA