NTSB investigations: Mooney M20F, WA
7 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1976 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 2003 | 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\" = 'WA' 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" = 'WA' 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 SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.NTSB SEA91LA236Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kent, WAFailure of the pilot to maintain directional control and proper runway alignment during the landing and go-around (aborted landing). Factors related to the accident were: the pilot's improper flare and improper recovery from a bounced landing, which resulted…NTSB SEA86LA205Accident · No injuriesLimited investigationFinal reportMooney M20 · Quincey, WAThe pilot stated he had mad a normal landing on a paved city street in a housing dvelopment thinking that it was the Quincey municipal airport. After the pilot realized he ahd made a mistake a take off was attempted. During the take off the pilot aborted the…NTSB SEA83LA195Accident · No injuriesLimited investigationFinal reportMooney M20-F · Seattle, WAThe plt stated he experienced a complete power loss while flying over puget sound at 700 ft. the acft sank & was not recovered.NTSB SEA77FYG08Accident · No injuriesClosedMooney M20F · Palouse, WANTSB SEA71DYG47Accident · No injuriesClosedMooney M20F · Lacrosse, WANTSB SEA70AS036Accident · 3 fatalClosedMooney M20F · Cougar, WA