NTSB investigations: Mooney M20C, IL
24 cases on aircraft the registry lists as Mooney M20C. 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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 3 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 2008 | 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\" = 'IL' 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 ('5870208'))
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" = 'IL' 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 ('5870208'))
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 CHI08CA283Accident · Minor injuriesData collectionFinal reportMooney M20C · Bolingbrook, ILThe non-mechanical loss of engine power due to the pilot's incorrect positioning of the fuel tank selector prior to takeoff and the subsequent fuel starvation during takeoff.NTSB CHI80FA043Accident · 3 fatalClosedMooney M20C · Byron, ILNTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILNTSB CHI77FA007Accident · 1 fatalClosedMooney M20C · Peoria, ILNTSB CHI76AC056Accident · 1 fatalClosedPiper PA-28R · Blue Mound, ILNTSB CHI75FEV40Accident · Minor injuriesClosedMooney M20C · Lewiston, ILNTSB CHI75DEE50Accident · No injuriesClosedMooney M20C · Grant Park, ILNTSB CHI75DEV01Accident · No injuriesClosedMooney M20 · Mt Vernon, ILNTSB CHI74FEV53Accident · Serious injuriesClosedMooney M20C · Watseka, ILNTSB CHI73FEE02Accident · No injuriesClosedMooney M20C · Joliet, ILNTSB CHI72FEE89Accident · Minor injuriesClosedMooney M20C · Lansing, ILNTSB CHI72FEE73Accident · No injuriesClosedMooney M-20C · Northbrook, ILNTSB CHI71FBQ30Accident · Serious injuriesClosedMooney M20C · Virden, ILNTSB CHI70FBD31Accident · Serious injuriesClosedMooney M20C · Palos Hills, ILNTSB CHI69F0662Accident · Minor injuriesClosedMooney M20C · Northbrook, ILNTSB CHI69F0575Accident · No injuriesClosedMooney M20C · Joliet, ILNTSB CHI69F0506Accident · No injuriesClosedMooney M20C · Effingham, ILNTSB CHI68D0557Accident · No injuriesClosedMooney M20C · Kankakee, ILNTSB CHI68D0163Accident · No injuriesClosedMooney M20C · Ringwood, ILNTSB CHI68D0162Accident · No injuriesClosedMooney M20 · Moline, ILNTSB CHI67D0233Accident · No injuriesClosedMooney M20C · Chicago, ILNTSB CHI66D0053Accident · No injuriesClosedMooney M20C · Hillsboro, ILNTSB CHI65F0145Accident · No injuriesClosedMooney M20 · Canton, ILNTSB UNK65X0312Accident · 3 fatalClosedMooney M20C · Antioch, IL