NTSB investigations: Mooney M20F, MD
5 cases on aircraft the registry lists as Mooney M20F. 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
| 1973 | 1 |
|---|---|
| 1982 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 2002 | 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\" = 'MD' 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 ('5870214'))
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" = 'MD' 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 ('5870214'))
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 NYC02LA119Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Hagerstown, MDThe pilot's failure to perform a go-around and obtain the proper touchdown point, which resulted in an overrun. A factor in the accident was the crosswind condition.NTSB BFO89LA052Accident · Minor injuriesLimited investigationFinal reportMooney M-20F · Mchenry, MDThe pilot landed hard and collapsed the landing gear when he failed to arrest his descent rate during landing. Afterwardas he tried to make a go-around the pilot did not obtain adequate flying speed, the aircraft stalled and collided with the ground.NTSB BFO85FA041Accident · No injuriesField investigationFinal reportMooney M20F · Stevensville, MDThe plt stated that when in normal curise at 3000 ft over castle marina arpt he noticed excessive oil and cylinder head temps. A concurrent small amount of smoke was emanating from the instrument panel which prompted the plt to execute a precautionary lndg at…NTSB ATL82FA086Accident · 3 fatalField investigationFinal reportMooney M20F · Mchenry, MDAt 0635 the plt received a wx briefing which included forecasted icing conditions along his route of flt. At 1215 received an updated briefing & was informed that IMC existed along his route of flt & VFR flt was not recommended. At 1536 he called & received…NTSB NYC73AN096Accident · 3 fatalClosedMooney M20F · Elkton, MD