NTSB investigations: Mooney M20F, OR

11 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

NTSB investigations: Mooney M20F, OR per year, 1967–2026: 11 cases
1967	2
1968	2
1971	1
1972	1
1982	2
1985	1
1987	2

Where

Open the map

Latest cases

Query with SQL

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 ('5870214')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('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" = '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 ('5870214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 SEA87LA096Accident · No injuriesLimited investigationFinal reportMooney M20F · Wagontire, ORDuring takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck…May 17, 1987 · N3523X · Substantial damage NTSB SEA87LA128Accident · No injuriesLimited investigationFinal reportMooney M20F · Grants Pass, ORShortly after takeoff the pilot realized that he had no airspeed indication due to his forgetting to remove the pitot cover during preflight. The pilot returned to land at the airport and landed gear up.Apr 3, 1987 · N6901V · Substantial damage NTSB SEA85LA161Accident · No injuriesLimited investigationFinal reportMooney M20-F · Salem, ORThe acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be…Jul 11, 1985 · N6879V · Substantial damage NTSB SEA82DA135Accident · No injuriesFinal reportMooney M20F · Sandy, ORAfter the engine was overhauled, the pilot and a mechanic took off on a test flight. During the takeoff climb the engine lost power and when force landed on soft terrain, the nose and right main landing gear collapsed. An examination revealed that the left…Jul 31, 1982 · N9707M · Substantial damage NTSB SEA82DA039Accident · Minor injuriesFinal reportMooney M20F · Maupin, ORThe pilot reported that the engine lost power during takeoff after he raised the gear and flaps. He stated that he lowered the nose and the stall warning buzzer sounded, but he was unable to obtain the necessary airspeed. He stated that the power began to…Mar 18, 1982 · N6879V · Substantial damage NTSB SEA72FYC39Accident · No injuriesClosedMooney M20F · Tigard, ORMay 3, 1972 · N9590M · Substantial damage NTSB SEA72AS017Accident · 2 fatalClosedMooney M20F · Azalea, OROct 11, 1971 · N6432Q · Destroyed NTSB OAK69A0022Accident · 3 fatalClosedMooney M20F · Cotage Grove, OROct 17, 1968 · N78889 · Destroyed NTSB SEA69A0002Accident · 2 fatalClosedMooney M20F · Cascadia, ORJul 4, 1968 · N9527M · Destroyed NTSB SEA68A0019Accident · 3 fatalClosedMooney M20F · Albany, ORAug 20, 1967 · N2979L · Destroyed NTSB SEA67D0258Accident · Minor injuriesClosedMooney M20B · North Powder, ORMar 11, 1967 · N78910 · Substantial damage