Skip to content

NTSB investigations: Cessna 150H, WA

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

19682026

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" = '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 ('2071818')) 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\" = '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 ('2071818'))
  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 ('2071818'))
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 WPR20LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Port Orchard, WAThe pilot's delayed decision to go around from an unstable approach, which resulted in insufficient airplane performance to climb above rising terrain and a subsequent aerodynamic stall.Jul 8, 2020 · N22393 · Substantial damage NTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.Apr 7, 2012 · N6616S · Substantial damage NTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.Apr 24, 2011 · N23295 · Substantial damage NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.Jul 24, 2009 · N22278 · Substantial damage NTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.Apr 13, 2000 · N50039 · Substantial damage NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…Feb 18, 2000 · N50348 · Substantial damage NTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.Aug 22, 1993 · N22369 · Substantial damage NTSB SEA92LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Packwood, WAThe improper in-flt planning and decision by the student pilot and his failure to maintain terrain clearance. Factors relating to the accident were the box canyon and the rising mountainous terrain.Sep 16, 1992 · N6419S · Destroyed NTSB SEA91LA172Accident · No injuriesLimited investigationFinal reportCessna 150H · Shelton, WAInadequate preflight planning/preparation by the pilot in command. Factors to the accident were: delayed go-around gusting winds, poor compensation for wind conditions, and unsuitable terrain.Jul 13, 1991 · N50081 · Substantial damage NTSB SEA83LA117Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAThe acft nosed over during an off airport forced landing. The student pilot had checked with her father and flight instructor for her cross-country flight. Her father supplied information on the fuel supply and the student and instructor used this information…Jun 7, 1983 · N22670 · Substantial damage NTSB SEA83LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Yakima, WAAircraft lost power during night cross-country and was landed on a highway. During landing the aircraft collided with a pickup truck a tree and a fence. The aircraft had run out of fuel.Jan 29, 1983 · N22824 · Destroyed NTSB SEA82DA042Accident · No injuriesFinal reportCessna 150H · Camas, WADuring the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing.Mar 30, 1982 · N22609 · Substantial damage NTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WAOct 6, 1978 · N22421 · Destroyed NTSB SEA77DYP36Accident · No injuriesClosedCessna 150H · Nespelem, WAAug 6, 1977 · N8863R · Substantial damage NTSB SEA75AS029Accident · 1 fatalClosedCessna 150H · Auburn, WAJan 30, 1975 · N23419 · Destroyed NTSB SEA74DYE14Accident · No injuriesClosedCessna 150 · Federal Way, WAAug 21, 1973 · N7296S · Substantial damage NTSB SEA72FYE37Accident · Serious injuriesClosedCessna 150H · Alderwd Manr, WAJun 29, 1972 · N7106S · Substantial damage NTSB SEA72DYE21Accident · No injuriesClosedCessna 150 · Auburn, WAJan 30, 1972 · N22609 · Substantial damage NTSB SEA70DWD21Accident · No injuriesClosedCessna 150 · Snohomish, WAJun 23, 1970 · N6798S · Substantial damage NTSB SEA70F0129Accident · Serious injuriesClosedCessna 150H · Spokane, WADec 15, 1969 · N22640 · Destroyed NTSB SEA70D0083Accident · No injuriesClosedCessna 150H · Colfax, WASep 1, 1969 · N6585S · Substantial damage NTSB SEA69F0226Accident · Minor injuriesClosedCessna 150H · Fall City, WAApr 10, 1969 · N6984S · Substantial damage NTSB SEA69F0212Accident · Serious injuriesClosedCessna 150 · Kittitas, WAMar 26, 1969 · N7252S · Destroyed NTSB SEA69D0179Accident · No injuriesClosedCessna 150 · Silverdale, WAJan 17, 1969 · N6798S · Substantial damage NTSB SEA69A0028Accident · 1 fatalClosedCessna 150H · Spirit Lake, WANov 10, 1968 · N22166 · Destroyed NTSB SEA69D0111Accident · No injuriesClosedCessna 150 · Pullman, WASep 12, 1968 · N7286S · Substantial damage NTSB SEA68A0060Accident · 4 fatalClosedCessna 172 · Puyallup, WAMar 24, 1968 · N6069A · 2 aircraft · Destroyed