Skip to content

NTSB investigations: Cessna 150G, WA

33 cases on aircraft the registry lists as Cessna 150G. 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" = '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 ('2071816')) 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 ('2071816'))
  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 ('2071816'))
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 SEA05CA112Accident · No injuriesData collectionFinal reportCessna 150G · Buckley, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power due to carburetor ice and a forced landing. Contributing factors were the carburetor icing conditions and the lack of suitable terrain for the forced landing.Jun 8, 2005 · N2751S · Substantial damage NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.Jan 13, 2002 · N2669J · Destroyed NTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…Jan 7, 2000 · N3721J · Substantial damage NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.Jul 8, 1996 · N8310J · Substantial damage NTSB SEA96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Vancouver, WAthe pilot's failure to use carburetor heat, and his delay in aborting the takeoff after noting sluggish acceleration. Factors were: the carburetor icing conditions, the trees off the end of the runway, and the soft ground conditions in the forced landing area.Feb 19, 1996 · N3272J · Substantial damage NTSB SEA96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Douglas, WAThe pilot fell asleep.Nov 12, 1995 · N3900J · Substantial damage NTSB SEA95LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Stehekin, WAThe pilot's failure to maintain airspeed after takeoff.Sep 3, 1995 · N4016J · Substantial damage NTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.Nov 13, 1993 · N2446J · Destroyed NTSB SEA91FA069Accident · 2 fatalField investigationFinal reportCessna 150G · Kennewick, WAImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and his failure to maintain adequate airspeed, while maneuvering to make a forced landing, which resulted in a stall.Mar 27, 1991 · N4065J · Destroyed NTSB SEA87FA129Accident · 2 fatalField investigationFinal reportCessna 150G · Vashon, WAAircraft departed on a routine instructional flight. Radar track indicated aircraft engaging in maneuvers typical of instructional high work (stalls/turn/slow flight) followed by left orbit about grass airstrip used only for practice emergency landing…Jul 4, 1987 · N3736J · Destroyed NTSB SEA85LA154Accident · No injuriesLimited investigationFinal reportCessna 150G · Asotin, WAWhile maneuvering, the aircrafts engine sputtered and then quit. During forced landing on a freshly plowed field, the aircrafts nose wheel dug in and collapsed. The acircraft nosed over. The aircraft was examined by an a & p mechanic and no abnormalities…Jun 29, 1985 · N3814J · Substantial damage NTSB SEA82DA060Accident · No injuriesFinal reportCessna 150G · Camas, WAAfter receiving 2.9 hrs of dual instruction in this make and model of aircraft, the student proceeded on a supervised solo flight. The first approach and landing were observed by the instructor to be normal. The second approach was made with 20 degrees of…Apr 28, 1982 · N3691J · Substantial damage NTSB SEA82FA011Accident · 2 fatalClosedCessna 150G · Renton, WANov 26, 1981 · N4737X · Destroyed NTSB SEA80FYP17Accident · No injuriesClosedCessna 150G · Grandview, WAApr 1, 1980 · N2681J · Substantial damage NTSB SEA79DYP27Accident · No injuriesClosedCessna 150 · Garfield, WAJun 7, 1979 · N3312J · Substantial damage NTSB SEA76FYG29Accident · Serious injuriesClosedCessna 150 · Spokane, WAJan 19, 1976 · N3423J · Substantial damage NTSB SEA75DYE48Accident · Minor injuriesClosedCessna 150 · Blaine, WAJun 18, 1975 · N8364J · Substantial damage NTSB SEA74DYE16Accident · No injuriesClosedCessna 150 · Aldrwood Mnr, WAJun 30, 1973 · N8606J · Minor damage NTSB SEA73FYE22Accident · Minor injuriesClosedCessna 150 · Renton, WADec 8, 1972 · N3230J · Substantial damage NTSB SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · Destroyed NTSB SEA72FYE02Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 3, 1971 · N3139X · Destroyed NTSB SEA71FYE34Accident · No injuriesClosedCessna 150 · Issaquah, WAJun 9, 1971 · N3235J · Substantial damage NTSB SEA71DYG57Accident · No injuriesClosedCessna 150 · Bridgeport, WAMay 25, 1971 · N3164X · Substantial damage NTSB SEA71DWG16Accident · No injuriesClosedCessna 150G · Easton, WASep 9, 1970 · N3902J · Substantial damage NTSB SEA70FWG12Accident · No injuriesClosedCessna 150G · Wenatchee, WAMay 1, 1970 · N3694J · Substantial damage NTSB SEA70FWD01Accident · No injuriesClosedCessna 150 · Snohomish, WAJan 18, 1970 · N2415J · Substantial damage NTSB SEA70D0096Accident · Minor injuriesClosedCessna 150 · Sultan, WAAug 11, 1969 · N3052S · Destroyed NTSB SEA69D0218Accident · No injuriesClosedCessna 150G · Vancouver, WAMar 16, 1969 · N3423J · Substantial damage NTSB SEA69D0190Accident · Minor injuriesClosedCessna 150G · Ephrata, WAFeb 27, 1969 · N3902J · Substantial damage NTSB SEA69F0198Accident · No injuriesClosedCessna 150 · Chehalis, WAFeb 13, 1969 · N3198J · Substantial damage NTSB SEA68D0323Accident · Minor injuriesClosedCessna 150 · Kent, WAMay 9, 1968 · N2299J · Substantial damage NTSB SEA68D0073Accident · No injuriesClosedCessna 150 · Tacoma, WAJun 20, 1967 · N2723S · Substantial damage NTSB SEA67D0202Accident · No injuriesClosedCessna 150 · Pasco, WANov 12, 1966 · N3986J · Substantial damage