Skip to content

NTSB investigations: Cessna 150E, WA

15 cases on aircraft the registry lists as Cessna 150E. 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 ('2071812')) 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 ('2071812'))
  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 ('2071812'))
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 WPR26LA327Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150E · Siler, WAOn September 1, 2026, at 1220 Pacific daylight time, a Cessna 150E, N3037J, sustained substantial damage when it was involved in an accident near Siler, Washington. The pilot and pilot rated passenger were not injured. The airplane was operated as a Title 14…Sep 1, 2026 · N3037J · Substantial damage NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.Apr 22, 1999 · N48612 · 2 aircraft · Substantial damage NTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.Nov 22, 1991 · N2582J · 2 aircraft · Destroyed NTSB SEA83LA160Accident · No injuriesLimited investigationFinal reportCessna 150E · Ellensburg, WAThe acft landing gear collapsed during a forced landing on a rough road. The acft engine had quit while climbing THROUGH4500 ft after takeoff. The pilot tried leaning and pitot heat. Since the engine would not start the pilot picked a dirt road for landing.…Jul 27, 1983 · N4098U · Substantial damage NTSB SEA83LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Issaquah, WADuring takeoff on a glider towing operation, the eng lost power at aprx 200 to 250 ft AGL. The glider plt disengaged from the tow plane & the tow plt commenced a power off descent to land on a road. There was conflicting traffic on the road. At about the same…Jul 21, 1983 · N6272T · Destroyed NTSB SEA83LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelso, WAThe plt hand-propped the acft with a non-plt at the controls. The acft was then taxied to the fuel pumps & fueled. The acft was then hand-propped again with no chocks used. The non-plt was at the controls. The acft started to move, & the plt climbed into the…May 28, 1983 · N6222R · Substantial damage NTSB SEA80FYP05Accident · Minor injuriesClosedCessna 150E · Moses Lake, WANov 26, 1979 · N4098U · Substantial damage NTSB SEA77DYP13Accident · Minor injuriesClosedCessna 150E · Spangle, WADec 8, 1976 · N6286T · Substantial damage NTSB SEA75FYC45Accident · No injuriesClosedCessna 150 · Vancouver, WAJun 27, 1975 · N4055U · 2 aircraft · Substantial damage NTSB SEA71FWG28Accident · No injuriesClosedCessna 150E · Wenatchee, WAOct 8, 1970 · N2532J · Substantial damage NTSB SEA71FWA20Accident · No injuriesClosedCessna 150E · Vancouver, WASep 27, 1970 · N3046J · Substantial damage NTSB SEA70F0106Accident · Minor injuriesClosedCessna 150 · Takoma, WASep 24, 1969 · N3538J · Substantial damage NTSB SEA69D0175Accident · No injuriesClosedCessna 150 · Bellingham, WAJan 2, 1969 · N6264T · Substantial damage NTSB SEA68D0263Accident · No injuriesClosedCessna 150 · Port Orchard, WAMar 17, 1968 · N3070J · Substantial damage NTSB SEA66F0207Accident · Serious injuriesClosedCessna 150 · Pullman, WAJan 30, 1966 · N4074U · Destroyed