Skip to content

NTSB investigations: Cessna 150G, AK

26 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

19702026

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" = 'AK' 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\" = 'AK' 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" = 'AK' 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 GAA17CA542Accident · No injuriesData collectionFinal reportCessna 150 · Wasilla, AKThe student pilot’s inadequate in-flight fuel planning, which resulted in fuel exhaustion, the subsequent total loss of engine power, and a forced off-airport landing.Aug 31, 2017 · N2996S · Substantial damage NTSB ANC15CA058Accident · No injuriesData collectionFinal reportCessna 150G · Mekoryuk, AKThe pilot's improper decision to land on an unsuitable landing surface which resulted in a nose over.Jul 20, 2015 · N3392J · Substantial damage NTSB ANC12CA045Accident · No injuriesData collectionFinal reportCessna 150G · Ketchikan, AKThe pilot’s decision to take off with a quartering tailwind, which resulted in a loss of control.Jun 3, 2012 · N3235J · Substantial damage NTSB ANC07LA090Accident · No injuriesLimited investigationFinal reportCessna 150G · Kenai, AKThe pilot's excessive flap setting during takeoff.Aug 25, 2007 · N2981S · Substantial damage NTSB ANC02LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch. A contributing factor in the accident was the presence of a ditch in the landing area.Jun 10, 2002 · N8623J · Substantial damage NTSB ANC02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…Feb 5, 2002 · N3829J · Substantial damage NTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.Apr 22, 2001 · N8401J · Substantial damage NTSB ANC96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Hoonah, AKthe pilot's inadequate preflight planning/preparation. Factors relating to the accident were: improper weight and balance configuration, and unsuitable terrain in the emergency landing area.Oct 6, 1995 · N4024J · Substantial damage NTSB ANC94LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's inadequate preflight planning and preparation.Aug 21, 1994 · N2677J · Substantial damage NTSB ANC93LA011Accident · No injuriesLimited investigationFinal reportCessna 150G · Delta Junction, AKThe pilot in command's (CFI) in flight planning/decision to attempt a down wind forced landing in high surface wind conditions and the pilot's improper use of carburetor heat.Nov 3, 1992 · N3144X · Substantial damage NTSB ANC92LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Black River, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude to clear the terrain. Contributing to the accident were the pilot's lack of familiarity with the geographic area, and his lack of total experience in the type…Aug 12, 1992 · N6288S · Substantial damage NTSB ANC92LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · Juneau, AKThe pilot failed to maintain directional control during the landing roll.Mar 15, 1992 · N3235J · Substantial damage NTSB ANC89LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Duffys Tavern, AKThe selection of the soft sandy strip for takeoff by the pilot and his premature liftoff combined to make it impossible to attain climb airspeed before colliding with bushes at the end of the runway.Jul 1, 1989 · N3200X · Substantial damage NTSB ANC83LA047Accident · No injuriesLimited investigationFinal reportCessna 150G · North Pole, AKThe student & instructor plt (CFI) were on an instructional flt on a cold winter day (temp -10 deg f). The CFI stated that while practicing turns at 3000 ft MSL, he closed the throttle to give the student a forced landing excercise. He stated that carburetor…Feb 21, 1983 · N8541J · Substantial damage NTSB ANC81DAA05Accident · Minor injuriesClosedCessna 150 · Gold King Crk, AKNov 1, 1980 · N496RA · Substantial damage NTSB ANC79DAG33Accident · Minor injuriesClosedCessna 150 · Anchorage, AKFeb 27, 1979 · N2467J · Substantial damage NTSB ANC78DAG80Accident · No injuriesClosedCessna 150 · Lake Louise, AKMar 1, 1978 · N6349S · Substantial damage NTSB ANC78DAG01Accident · Minor injuriesClosedCessna 150 · Gulkana, AKOct 12, 1977 · N8437J · Substantial damage NTSB ANC77DAG67Accident · No injuriesClosedCessna 150 · Anchorage, AKJun 15, 1977 · N2628J · Substantial damage NTSB ANC76AA130Accident · 3 fatalClosedCessna 150 · Wrangell, AKSep 11, 1976 · N4710X · Destroyed NTSB ANC73DAA18Accident · No injuriesClosedCessna 150G · Nenana, AKDec 14, 1972 · N2882S · Substantial damage NTSB ANC72DAG93Accident · No injuriesClosedCessna 150G · Palmer, AKFeb 13, 1972 · N6288S · Substantial damage NTSB ANC72AA005Accident · 2 fatalClosedCessna 150G · Petersburg, AKJul 25, 1971 · N8697J · Substantial damage NTSB ANC71FAG63Accident · Minor injuriesClosedCessna 150G · Anchorage, AKJan 22, 1971 · N2785S · Substantial damage NTSB ANC71AA003Accident · 2 fatalClosedCessna 150 · Wasilla, AKJul 11, 1970 · N2782S · Destroyed NTSB ANC70DAG26Accident · No injuriesClosedCessna 150G · Anchorage, AKJun 16, 1970 · N2782S · Substantial damage