Skip to content

NTSB investigations: Cessna 150L, AL

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

19722026

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" = 'AL' 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 ('2071826')) 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\" = 'AL' 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 ('2071826'))
  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" = 'AL' 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 ('2071826'))
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 GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.Jun 28, 2015 · N19337 · Substantial damage NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.Nov 25, 2013 · N16078 · Substantial damage NTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.Jun 6, 2004 · N10424 · Substantial damage NTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.Jan 18, 1998 · N7443G · Substantial damage NTSB ATL94LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Hazel Green, ALThe loss of engine power when the fractured piece of the rocker boss interrupted the normal operation of a movable component under the valve cover. A factor was the soft terrain in the landing area.Apr 11, 1994 · N11560 · Substantial damage NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.Sep 14, 1991 · N6866G · Substantial damage NTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALDec 9, 1981 · N11623 · Substantial damage NTSB ATL80DKJ24Accident · No injuriesClosedCessna 150 · Hartselle, ALAug 8, 1980 · N1640Q · Substantial damage NTSB MIA78DKJ58Accident · No injuriesClosedCessna 150 · Talladega, ALJul 8, 1978 · N6916G · Substantial damage NTSB MIA77DKJ32Accident · No injuriesClosedCessna 150 · Holtville, ALApr 17, 1977 · N18645 · Substantial damage NTSB MIA77FKJ20Accident · Serious injuriesClosedCessna 150L · Tuscumbia, ALMar 4, 1977 · N7785G · Destroyed NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB MIA76DKJ58Accident · No injuriesClosedCessna 150L · Jasper, ALApr 18, 1976 · N1634Q · Substantial damage NTSB MIA76DKJ15Accident · No injuriesClosedCessna 150 · Sardis, ALAug 26, 1975 · N11535 · Destroyed NTSB MIA76DKJ09Accident · No injuriesClosedCessna 150 · Jasper, ALAug 2, 1975 · N1523Q · Substantial damage NTSB MIA75DKJ56Accident · No injuriesClosedCessna 150 · Huntsville, ALApr 16, 1975 · N18212 · Substantial damage NTSB MIA74AM075Accident · 2 fatalClosedCessna 150L · Bessemer, ALFeb 26, 1974 · N1355Q · Destroyed NTSB MIA73DKJ59Accident · Serious injuriesClosedCessna 150 · Talledega, ALMay 15, 1973 · N6604G · Destroyed NTSB MIA73DKJ32Accident · No injuriesClosedCessna 150L · Ozark, ALOct 29, 1972 · N5228Q · Substantial damage