NTSB investigations: Mooney M20E, IN
10 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 |
| 1968 | 3 |
| 1969 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 2007 | 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\" = 'IN' 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" = 'IN' 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 CHI08CA035Accident · No injuriesData collectionFinal reportMooney M20E · Lafayette, INThe improper installation of the connecting rod bolts during major overhaul, which resulted in the separation of the connecting rod from the crankshaft in flight. Contributing to the accident was the rising terrain encountered during touchdown and the…NTSB CHI84FA027Accident · 2 fatalField investigationFinal reportMooney M20E · Newark, INThe acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…NTSB CHI77EEX44Accident · No injuriesClosedMooney M20E · Greenwood, INNTSB CHI74FEA27Accident · No injuriesClosedMooney M20E · Tunnelton, INNTSB CHI69A0075Accident · 1 fatalClosedMooney M20E · Jeffersonvlle, INNTSB CHI69D0250Accident · No injuriesClosedMooney M20E · Mentone, INNTSB CHI69F0174Accident · No injuriesClosedMooney M20E · Camden, INNTSB CHI69F0087Accident · Serious injuriesClosedMooney M20E · Gary, INNTSB CHI68F0217Accident · No injuriesClosedMooney M20E · South Bend, INNTSB CHI67D0278Accident · No injuriesClosedMooney M20E · Richmond, IN