Skip to content

NTSB investigations: Cessna 150F, OR

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

19662026

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 ('2071814')) 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 ('2071814'))
  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 ('2071814'))
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 GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.Sep 21, 2018 · N8382G · Substantial damage NTSB WPR10LA168Accident · No injuriesLimited investigationFinal reportCessna 150F · Tillamook, ORThe partial loss of engine power during climb to cruise due to carburetor icing and the pilot's delay in using carburetor heat.Mar 17, 2010 · N7854F · Substantial damage NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.Apr 19, 2003 · N7057F · Substantial damage NTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.Mar 9, 1996 · N8920S · Substantial damage NTSB SEA90LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Redmond, ORThe student pilot's failure to properly recover from a bounced landing.Jul 24, 1990 · N8756G · Substantial damage NTSB SEA87LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Perrydale, ORThe acft descended to terrain impact during a descent for landing. The plt stated he recalled entering a descent so he would be at 1,000 ft MSL on crosswind for landing. The plt does not recall any further details concerning the accident due to head injuries.Oct 14, 1986 · N8184F · Destroyed NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…May 19, 1984 · N6511F · Destroyed NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.May 6, 1982 · N6701F · Substantial damage NTSB SEA79FYK29Accident · Minor injuriesClosedCessna 150F · Cottage Grove, ORSep 9, 1979 · N8937S · Substantial damage NTSB SEA79DYK30Accident · No injuriesClosedCessna 150 · Eugene, ORSep 8, 1979 · N7091F · Substantial damage NTSB SEA79FA032Accident · 1 fatalClosedCessna 150 · John Day, ORMay 1, 1979 · N7753F · Destroyed NTSB SEA73FYC32Accident · Minor injuriesClosedCessna 150F · Oregon City, ORJun 7, 1973 · N8814G · Substantial damage NTSB SEA70FWA02Accident · No injuriesClosedCessna 150F · Donald, ORFeb 1, 1970 · N8135S · Substantial damage NTSB SEA69F0199Accident · Minor injuriesClosedCessna 150F · Goshen, ORFeb 13, 1969 · N8920S · Destroyed NTSB SEA69D0050Accident · No injuriesClosedCessna 150 · Springfield, ORMay 31, 1968 · N6716F · Substantial damage NTSB SEA68D0285Accident · No injuriesClosedCessna 150 · Florence, ORMar 14, 1968 · N7112F · Substantial damage NTSB SEA68F0125Accident · No injuriesClosedCessna 150F · Beaverton, ORAug 1, 1967 · N8419G · Substantial damage NTSB SEA68D0118Accident · No injuriesClosedCessna 150F · Sutherlin, ORJul 16, 1967 · N6533F · Substantial damage NTSB SEA68D0052Accident · Serious injuriesClosedCessna 150 · Albany, ORMay 21, 1967 · N8727G · No damage NTSB SEA67D0282Accident · Minor injuriesClosedCessna 150 · Chemult, ORFeb 22, 1967 · N8431G · Substantial damage NTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORAug 25, 1966 · N6533F · Substantial damage NTSB SEA67F0056Accident · No injuriesClosedCessna 150 · Portland, ORMay 26, 1966 · N3576L · Substantial damage NTSB SEA66F0274Accident · No injuriesClosedCessna 150 · Albany, ORApr 9, 1966 · N6767F · Substantial damage