Skip to content

NTSB investigations: Cessna 150H, AL

27 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

19682026

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 ('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\" = '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 ('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" = '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 ('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 ERA21LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Carrollton, ALThe pilot’s incorrect preflight planning and poor in-flight planning, resulting in fuel exhaustion. Contributing to the damage was the inadvertent encounter with a hole during the forced landing.Jul 1, 2021 · N561QL · Substantial damage NTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…Oct 26, 2013 · N684RA · Substantial damage NTSB ERA12CA390Accident · No injuriesData collectionFinal reportCessna 150H · Alabaster, ALThe pilot's failure to maintain directional control while landing in gusting wind conditions.Jun 9, 2012 · N6963S · Substantial damage NTSB ATL96LA080Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALfailure of the pilot to maintain directional control of the airplane during a go-around. A factor relating to the accident was: improper flare by the pilot during the landing.Apr 14, 1996 · N23298 · Substantial damage NTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayMay 29, 1993 · N6924S · Substantial damage NTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…Oct 14, 1987 · N22553 · Substantial damage NTSB ATL87LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Andalusia, ALThe CFI was giving instruction to a beginning student. During preflight he noted that the lt tank fuel gauge indicated 'full' while the rt tank gauge inidated '1/2 full '. After about 40 minutes of flying the engine began to run rough, during climbout after a…Jun 1, 1987 · N22553 · Substantial damage NTSB ATL85LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · Enterprise, ALWhile on a solo training flight the aircraft lost power while on downwind and the student pilot made an mergency landing on the runway, however, during landing roll the aircraft went off the side of the rwy and nosed over in the soft soil. Post crash…Jul 10, 1985 · N22553 · Substantial damage NTSB ATL82FKJ06Accident · Serious injuriesClosedCessna 150 · Russellville, ALNov 11, 1981 · N7206S · Substantial damage NTSB ATL81DKJ31Accident · Minor injuriesClosedCessna 150 · Huntsville, ALAug 15, 1981 · N22626 · Destroyed NTSB ATL80DKJ02Accident · No injuriesClosedCessna 150 · Camden, ALMay 20, 1980 · N7017S · Substantial damage NTSB MIA78DKJ83Accident · No injuriesClosedCessna 150 · Pell City, ALAug 26, 1978 · N6581S · Substantial damage NTSB MIA77DKJ51Accident · No injuriesClosedCessna 150H · Birmingham, ALJun 25, 1977 · N6470S · Substantial damage NTSB MIA76DKJ27Accident · No injuriesClosedCessna 150H · Ashland, ALOct 12, 1975 · N22277 · Substantial damage NTSB MIA74AM048Accident · 1 fatalClosedCessna 150H · Ashland, ALNov 24, 1973 · N22591 · Destroyed NTSB MIA73DKJ72Accident · No injuriesClosedCessna 150H · Weaver, ALJun 29, 1973 · N22016 · Substantial damage NTSB MIA73DKJ60Accident · Minor injuriesClosedCessna 150H · Hazel Green, ALMay 21, 1973 · N22159 · Substantial damage NTSB MIA73FKJ52Accident · No injuriesClosedCessna 150 · Coden, ALApr 27, 1973 · N6611S · Substantial damage NTSB MIA72FKJ15Accident · No injuriesClosedCessna 150 · Gadsden, ALAug 11, 1971 · N22016 · Substantial damage NTSB MIA71DKJ62Accident · No injuriesClosedCessna 150H · Montevallo, ALJun 20, 1971 · N7012S · Substantial damage NTSB MIA71DKJ61Accident · No injuriesClosedCessna 150 · Detroit, ALJun 12, 1971 · N23197 · Substantial damage NTSB MIA71FKJ48Accident · No injuriesClosedCessna 150H · Weaver, ALApr 9, 1971 · N6520S · Substantial damage NTSB MIA71FKJ39Accident · Minor injuriesClosedCessna 150 · Brownsboro, ALJan 27, 1971 · N6698S · Substantial damage NTSB MIA70DKJ45Accident · No injuriesClosedCessna 150 · Laceys Sprngs, ALJun 22, 1970 · N6619S · Substantial damage NTSB MIA70D0250Accident · No injuriesClosedCessna 150H · Geneva, ALNov 28, 1969 · N6734S · Substantial damage NTSB MIA70F0254Accident · No injuriesClosedCessna 150F · Guntersville, ALOct 21, 1969 · N6484S · Substantial damage NTSB MIA69F0165Accident · No injuriesClosedCessna 150 · Pell City, ALSep 9, 1968 · N22614 · Substantial damage