Skip to content

NTSB investigations: Cessna 150H, AK

24 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

19692026

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 ('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\" = '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 ('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" = '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 ('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 ANC24LA086Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Tok, AKThe airplane’s encounter with gusting winds resulting in a loss of altitude with performance insufficient to outclimb terrain.Aug 31, 2024 · N41WP · Substantial damage NTSB ANC19LA015Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Talkeetna, AKA loss of pitch control for an undetermined reason, which resulted in a collision with terrain during an emergency landing.Mar 16, 2019 · N7095S · Substantial damage NTSB ANC09CA081Accident · No injuriesData collectionFinal reportCessna 150H · Talkeetna, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.Aug 12, 2009 · N6687S · Substantial damage NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.Jul 12, 2008 · N22563 · Substantial damage NTSB ANC97LA141Accident · No injuriesLimited investigationFinal reportCessna 150H · Yakutat, AKA partial blockage of the main fuel supply line to the engine, caused by improper manufacture of the fuel line by unknown maintenance personnel.Sep 2, 1997 · N467SR · Substantial damage NTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.Mar 3, 1996 · N22053 · Substantial damage NTSB ANC93LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Nondalton, AKThe inadequate preflight preparation by the pilot-in-command. A factor in the accident was the encounter with unsuitable terrain during the emergency descent.Jun 24, 1993 · N23224 · Substantial damage NTSB ANC82DA070Accident · Serious injuriesFinal reportCessna 150H · Near Anchorage, AKWhile taking off from a lake, the instructor reduced the power to simulate a forced landing at about 200 ft AGL. He reported that the student elected to make a 180 deg turn to land. He stated that during the turn, the student brought the nose up and the…Aug 4, 1982 · N22695 · Substantial damage NTSB ANC79DAA23Accident · No injuriesClosedCessna 150H · Fairbanks, AKJul 16, 1979 · N50296 · Substantial damage NTSB ANC79FAA16Accident · No injuriesClosedCessna 150 · Fairbanks, AKJun 16, 1979 · N23225 · Substantial damage NTSB ANC76FAA09Accident · No injuriesClosedCessna 150 · Fairbanks, AKJul 3, 1975 · N22690 · Substantial damage NTSB ANC74DAH10Accident · No injuriesClosedCessna 150 · Palmer, AKMay 21, 1974 · N22135 · Substantial damage NTSB ANC73DAG26Accident · No injuriesClosedCessna 150H · Homer, AKAug 27, 1972 · N22688 · Substantial damage NTSB ANC72FAG24Accident · Minor injuriesClosedCessna 150H · Skwentna, AKAug 14, 1971 · N22873 · Substantial damage NTSB ANC71DAG96Accident · No injuriesClosedCessna 150H · Cape Newenhm, AKJun 3, 1971 · N23147 · Substantial damage NTSB ANC71DAG80Accident · Minor injuriesClosedCessna 150H · Wasilla, AKApr 4, 1971 · N23223 · Substantial damage NTSB ANC71DAG75Accident · No injuriesClosedCessna 150H · Anchorage, AKMar 26, 1971 · N22873 · Substantial damage NTSB ANC71DAG79Accident · No injuriesClosedCessna 150H · Wasilla, AKMar 21, 1971 · N50019 · Substantial damage NTSB ANC71FAG51Accident · Minor injuriesClosedCessna 150 · Palmer, AKNov 30, 1970 · N22135 · Substantial damage NTSB ANC70FAG21Accident · No injuriesClosedCessna 150H · Ninilchik, AKMay 29, 1970 · N23147 · Substantial damage NTSB ANC70D0093Accident · Minor injuriesClosedCessna 150 · Galena, AKOct 20, 1969 · N50019 · Substantial damage NTSB ANC70F0049Accident · No injuriesClosedCessna 150H · Eagle River, AKSep 1, 1969 · N23223 · Substantial damage NTSB ANC69A0056Accident · 2 fatalClosedCessna 150 · Anchorage, AKMay 21, 1969 · N23041 · Destroyed NTSB ANC70D0007Accident · Serious injuriesClosedCessna 150 · Fairbanks, AKMay 19, 1969 · N22711 · Destroyed