Skip to content

NTSB investigations: Cessna 150F, AL

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

19652026

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 ('2071814')) 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 ('2071814'))
  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 ('2071814'))
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 ERA21LA284Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Elba, ALThe partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with trees during takeoff.Jul 11, 2021 · N8172S · Substantial damage NTSB MIA99LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150F · New Brockton, ALthe pilot's failure to perform fuel consumption calculations for the flight, resulting in a total power failure due to fuel exhaustion, and subsequent forced landing in soft terrain. Contributing factors in this accident were inadequate pre-flight planning…Nov 26, 1998 · N3060X · Substantial damage NTSB ATL90FA056Accident · Serious injuriesField investigationFinal reportCessna 150F · Weaver, ALThe pilot misjudged distance and altitude to the runway during a simulated engine-out approach, and failed to maintain clearance from trees. Factors related to the accident were: dusk light conditions, and the pilot's lack of recent experience in the make and…Jan 30, 1990 · N6871F · Substantial damage NTSB ATL88LA187Accident · No injuriesLimited investigationFinal reportCessna 150F · Mc Kenzie, ALThe plt reported that he attempted to takeoff from a pasture that was 'too short'. The airplane began to settle shortly after t/o and one of the MLG wheels struck a short post in the pasture. The airplane hdg was altered and the airplane crashed into a fence.…May 28, 1988 · N7067F · Destroyed NTSB ATL87LA109Accident · No injuriesLimited investigationFinal reportCessna 150F · Branchville, ALThe plt reported that the acft appeared to be 'hot' on final approach due to a tailwind, while ldg at the private airstrip. He initiated a go-around to avoid 50-60 ft trees at the FAR end of the rwy and made a climbing right turn. The stall warning system…Apr 11, 1987 · N8960S · Substantial damage NTSB ATL87FA052Accident · 2 fatalField investigationFinal reportCessna 150F · Newville, ALThe aircraft was observed flying at low levels during an orientation/pleasure flight for a friend's out-of-town relative visiting over the holidays. The professional military pilot had been checked out in the civilian Cessna 150 six weeks prior to the…Jan 1, 1987 · N8780S · Destroyed NTSB ATL84FA193Accident · 2 fatalField investigationFinal reportCessna 150F · Laceys Spring, ALA non-certificated plt made a steep turn after takeoff. The acft then entered a dive & impacted the ground in a steep nose low attitude. No record of pilot proficiency was found. Acquaintances reported that the plt had no training other than the minimum…Jun 5, 1984 · N8207S · Destroyed NTSB ATL82DA157Accident · No injuriesFinal reportCessna 150F · Monroeville, ALAfter making a normal landing touchdown, the nosewheel was held off until it lowered naturally. The pilot stated that when the nosewheel touched down, it seemed that the wheel would not turn. At about that time, the nose gear collapsed and the propeller,…Jun 6, 1982 · N8780S · Substantial damage NTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALMar 19, 1981 · N8207S · Substantial damage NTSB ATL80FKJ11Accident · Minor injuriesClosedCessna 150 · Decatur, ALJun 6, 1980 · N8584G · Substantial damage NTSB MIA78FKJ49Accident · No injuriesClosedCessna 150 · Auburn, ALJun 11, 1978 · N7195F · Substantial damage NTSB MIA76DKJ66Accident · No injuriesClosedCessna 150 · Russellville, ALJun 6, 1976 · N3060X · Substantial damage NTSB MIA75DKJ58Accident · No injuriesClosedCessna 150 · Huntsville, ALApr 29, 1975 · N8752G · Substantial damage NTSB MIA73DKJ29Accident · No injuriesClosedCessna 150 · Centre, ALOct 4, 1972 · N7941F · Substantial damage NTSB MIA73FKJ19Accident · Minor injuriesClosedCessna 150F · Weaver, ALSep 5, 1972 · N7984F · Substantial damage NTSB MIA72DKJ64Accident · No injuriesClosedCessna 150F · Mobile, ALJun 25, 1972 · N8192F · Substantial damage NTSB MIA71FKJ46Accident · No injuriesClosedCessna 150 · Florence, ALApr 11, 1971 · N8728S · Substantial damage NTSB MIA71FKJ30Accident · No injuriesClosedCessna 150 · Birmingham, ALNov 27, 1970 · N7046F · Substantial damage NTSB MIA71DKJ19Accident · No injuriesClosedCessna 150F · Enterprise, ALSep 27, 1970 · N8650S · Substantial damage NTSB MIA71DKJ11Accident · No injuriesClosedCessna 150 · Brundidge, ALJul 18, 1970 · N8196S · Substantial damage NTSB MIA70FKJ06Accident · Serious injuriesClosedCessna 150F · Glenwood, ALFeb 8, 1970 · N8869G · Destroyed NTSB MIA70F0111Accident · No injuriesClosedCessna 150F · St Elmo, ALJul 31, 1969 · N7752F · Substantial damage NTSB MIA70D0083Accident · No injuriesClosedCessna 150F · Ozark, ALJul 19, 1969 · N8207S · Substantial damage NTSB MIA69D0163Accident · No injuriesClosedCessna 150 · Skipperville, ALSep 7, 1968 · N8207S · Substantial damage NTSB MIA68A0104Accident · Minor injuriesClosedCessna 150F · Irvington, ALJun 9, 1968 · N8853S · Substantial damage NTSB MIA68D0287Accident · No injuriesClosedCessna 150 · Laceys Spring, ALNov 17, 1967 · N8745S · Substantial damage NTSB MIA68A0041Accident · 1 fatalClosedCessna 150 · Lacy Springs, ALOct 28, 1967 · N7797F · Destroyed NTSB MIA67D0559Accident · No injuriesClosedCessna 150F · Ashland, ALMay 30, 1967 · N3081X · Substantial damage NTSB MIA67D0338Accident · No injuriesClosedCessna 150F · Decatur, ALNov 30, 1966 · N7797F · Substantial damage NTSB MIA67F0302Accident · Serious injuriesClosedCessna 150F · Scottsboro, ALNov 6, 1966 · N8163F · Destroyed NTSB MIA67D0283Accident · No injuriesClosedCessna 150 · Eufaula, ALOct 30, 1966 · N8312G · Substantial damage NTSB MIA67F0276Accident · No injuriesClosedCessna 150 · Mobile, ALOct 22, 1966 · N7752F · Substantial damage NTSB MIA67D0314Accident · No injuriesClosedCessna 150 · Huntsville, ALOct 12, 1966 · N8728S · Substantial damage NTSB MIA66F0257Accident · Minor injuriesClosedCessna 150 · Birmingham, ALSep 16, 1965 · N8667S · Destroyed