Skip to content

NTSB investigations: Cessna 150M, OR

20 cases on aircraft the registry lists as Cessna 150M. 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

19652026

Where

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 ('2071830')) 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 ('2071830'))
  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 ('2071830'))
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 WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.Sep 3, 2012 · N3700V · Substantial damage NTSB SEA08CA143Accident · Minor injuriesData collectionFinal reportCessna 150M · Cove, ORThe pilot's failure to maintain clearance with terrain during a go-around.May 28, 2008 · N63422 · Substantial damage NTSB LAX08CA012Accident · No injuriesData collectionFinal reportCessna 150M · Hillsboro, ORThe pilot's misjudged and delayed landing flare that resulted in a hard landing and porpoise down the runway. Contributing factors in the accident were the night conditions and the optical illusion created by the narrow runway width and upsloping terrain.Oct 14, 2007 · N45720 · Substantial damage NTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.Jun 25, 1995 · N66727 · Substantial damage NTSB SEA93LA013Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Troutdale, ORImproper use of flt controls by the pilot, resulting in inadvertent stall/spin.Oct 30, 1992 · N66135 · Destroyed NTSB SEA92LA006Accident · Minor injuriesLimited investigationFinal reportCessna C-150M · Woodburn, ORA seized engine exhaust valve. Factors include rough terrain and a collapsed nose gear.Oct 14, 1991 · N9263U · Substantial damage NTSB SEA91LA239Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORInadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.Sep 16, 1991 · N714RK · Substantial damage NTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.Jul 31, 1991 · N9190U · Destroyed NTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.Sep 14, 1990 · N3420V · Destroyed NTSB SEA89FA176Accident · 2 fatalField investigationFinal reportCessna 150M · Cave Junction, ORThe pilot's improper handling of the aircraft due to the lack of recurrent training and recent experience which resulted in a loss of airspeed and a resultant stall. Contributing to the accident was the pilot's over-confidence in his ability to attempt flight…Sep 20, 1989 · N704TF · Substantial damage NTSB SEA88LA066Accident · No injuriesLimited investigationFinal reportCessna 150 · Fox, ORWhile departing an airstrip situated on top of a hill the aircraft was not able to clear power lines at the end of the airstrip. The pilot lowered the nose of the aircraft to clear the wires and the aircraft's elevator struck a road sign in flight. The…Mar 20, 1988 · N66727 · Substantial damage NTSB SEA88LA010Accident · No injuriesLimited investigationFinal reportCessna 150-M · Myrtle Creek, ORA loss of power occurred shortly after takeoff due to fuel exhaustion. A field was chosen for the off airport landing. During the landing rollout the aircraft struck a fence and raspberry bushes, collapsing the nose gear.Oct 18, 1987 · N7695U · Substantial damage NTSB SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.Mar 12, 1986 · N45174 · Substantial damage NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…Jul 22, 1982 · N8168U · Substantial damage NTSB SEA80DYM36Accident · No injuriesClosedCessna 150M · Yamhill, ORMay 17, 1980 · N63448 · Substantial damage NTSB SEA77DYM43Accident · Minor injuriesClosedCessna 150 · Troutdale, ORJun 24, 1977 · N45580 · Substantial damage NTSB SEA77FYM32Accident · 1 fatalClosedCessna 150M · Independence, ORMay 20, 1977 · N704BK · Destroyed NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB SEA76DYC59Accident · Serious injuriesClosedCessna 150M · Brightwood, ORJun 27, 1976 · N45611 · Destroyed NTSB SEA66D0129Accident · Minor injuriesClosedCessna 172 · Condon, ORSep 15, 1965 · N8872U · Substantial damage