NTSB investigations: Mooney M20E, MO
15 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1993 | 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\" = 'MO' 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" = 'MO' 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 CHI94LA058Accident · Serious injuriesLimited investigationFinal reportMooney M-20E · Chesterfield, MOthe pilot's failure to assure an adequate fuel supply for the planned flight. Factors associated with the accident were the trees, unreliable fuel gauges and the pilot's decision to operate the airplane with the known unreliable fuel gauges.NTSB CHI91LA085Accident · No injuriesLimited investigationFinal reportMooney M2OE · Rush Hill, MOThe pilot's failure to refuel the airplane. A factor related to the accident was unsuitable terrain.NTSB MKC84FCA02Accident · Serious injuriesFinal reportMooney M20E · Chesterfield, MOThe acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to…NTSB MKC75FCA16Accident · No injuriesClosedMooney M20E · Vichy, MONTSB MKC74FCA03Accident · Minor injuriesClosedMooney M20E · Fenton, MONTSB MKC73FCG17Accident · No injuriesClosedMooney M-20E · Versailles, MONTSB MKC72AK032Accident · 2 fatalClosedPiper PA-28 · Rutledge, MONTSB MKC71FCA13Accident · Minor injuriesClosedMooney M20E · Fenton, MONTSB MKC70D0032Accident · No injuriesClosedMooney M20E · Osage Beach, MONTSB MKC69D0130Accident · No injuriesClosedMooney M20E · Reeds Spring, MONTSB MKC68D0259Accident · No injuriesClosedMooney M-21 · Marshfield, MONTSB MKC67A0055Accident · 4 fatalClosedMooney M20E · Jefferson City, MONTSB MKC67D0091Accident · No injuriesClosedMooney M20E · Chesterfield, MONTSB MKC66F0300Accident · No injuriesClosedMooney M20 · Napoleon, MONTSB MKC66F0258Accident · No injuriesClosedMooney M20E · Carrollton, MO