NTSB investigations: Mooney M20C, AR
15 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1997 | 1 |
| 2008 | 1 |
| 2015 | 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\" = 'AR' 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" = 'AR' 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 CEN15LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Lonoke county, ARThe loss of engine power due to fuel starvation.NTSB DFW08CA180Accident · Minor injuriesData collectionFinal reportMooney M20 · Rogers, ARThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight planning/decision.NTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…NTSB MKC90LA097Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Little Rock, ARPilot in command's failure to refuel the airplane, which resulted in fuel exhaustion. Related to the accident was: unsuitable terrain in the emergency landing area.NTSB MKC89LA173Accident · No injuriesLimited investigationFinal reportMooney M20C · Fouke, ARThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion, at night. The ensuing forced landing resulted in a collision with a fencepost, ground swerve, and collapse of the right main landing gear.NTSB MKC87LA013Accident · No injuriesLimited investigationFinal reportMooney M20D · Johnson, ARThe plt had attempted a localizer apch to fayetteville, AK, and stated that his VOR indicator would not hold course. The plt then elected to abort the apch and land at a pvt strip near the fayetteville VOR. The plt was able to land at the strip but according…NTSB MKC84FA281Accident · 1 fatalField investigationFinal reportMooney M20C · New Blaine, ARDespite a wx briefing forecasting IMC and discouraging VFR flight, the non-instrument rated plt departed aprx 1 hour before the accident. Impact occurred in wooded rising terrain at an elevation of about 1,957 ft MSL at an aprx nose down attitude of 4 degs.…NTSB FTW79FPG70Accident · No injuriesClosedMooney M20C · Conway, ARNTSB FTW79FPG25Accident · Serious injuriesClosedMooney M20C · Hasty, ARNTSB FTW76FPG48Accident · No injuriesClosedMooney M20C · Siuttgart, ARNTSB FTW76AF052Accident · 4 fatalClosedMooney M20C · Strawberry, ARNTSB FTW71FPG63Accident · Serious injuriesClosedMooney M20C · Heber Springs, ARNTSB FTW69F0104Accident · Minor injuriesClosedMooney M20C · Lakeview, ARNTSB FTW6MD0120Accident · No injuriesClosedMooney M20C · Midway, ARNTSB FTW66F0098Accident · No injuriesClosedMooney M20C · Hope, AR