NTSB investigations: Mooney M20E, OR
19 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
| 1966 | 1 |
|---|---|
| 1967 | 5 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 2000 | 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\" = 'OR' 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" = 'OR' 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 WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…NTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.NTSB SEA88LA079Accident · Minor injuriesLimited investigationFinal reportMooney M20E · The Dalles, OROn arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state…NTSB SEA84LA189Accident · No injuriesLimited investigationFinal reportMooney M20E · Scappoose, ORPlt lowered gear in traffic pattern and gear down and locked green light was received. Plt failed to check the gear bar indicator. Acft touched down with gear extended 1/4 of the way. Inspection revealed landing gear motor bearingswere worn out.NTSB SEA81FYK06Accident · Minor injuriesClosedMooney M20C · Roseburg, ORNTSB SEA77FYM25Accident · 1 fatalClosedMooney M20E · Toledo, ORNTSB SEA75DYI26Accident · No injuriesClosedMooney M20C · Norway, ORNTSB SEA73DYI15Accident · No injuriesClosedMooney M20E · Bend, ORNTSB SEA73DYC19Accident · Serious injuriesClosedMooney M20E · Govt.Camp, ORNTSB SEA72FVC44Accident · Minor injuriesClosedMooney M20E · Corvallis, ORNTSB SEA71AS030Accident · 2 fatalClosedMooney M20E · Amity, ORNTSB SEA70F0131Accident · No injuriesClosedMooney M20E · Albany, ORNTSB SEA69D0177Accident · No injuriesClosedMooney M20E · Albany, ORNTSB SEA68D0184Accident · No injuriesClosedMooney M20C · Salem, ORNTSB SEA68D0087Accident · No injuriesClosedMooney M20E · Silverton, ORNTSB SEA68F0163Accident · Minor injuriesClosedMooney M20E · Beavertown, ORNTSB SEA68D0103Accident · No injuriesClosedMooney M20E · Burns, ORNTSB SEA67F0261Accident · No injuriesClosedMooney M20E · Pendleton, ORNTSB SEA66A0059Accident · 3 fatalClosedMooney M20E · Merrill, OR