Skip to content

NTSB investigations: Cessna 150H, GA

21 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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.May 2, 2021 · N6915S · Substantial damage NTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.Jul 11, 2016 · N23483 · Substantial damage NTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.May 20, 2008 · N7050S · Substantial damage NTSB ATL02LA145Accident · No injuriesLimited investigationFinal reportCessna 150H · Senoia, GAThe certificated flight instructor's failure to follow published procedures for the application of carburetor heat, which resulted in a loss of engine power due to carburetor ice formation, and subsequent collision with trees during the forced landing. A…Jul 28, 2002 · N6486S · Substantial damage NTSB MIA97LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Homerville, GAcarburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.Dec 3, 1996 · N6532S · Substantial damage NTSB ATL90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brookley, GAFuel exhaustion. Factors include improper planning/decision by the pilot-in-command.Sep 22, 1990 · N22909 · Destroyed NTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GAJan 14, 1988 · N12NF · Substantial damage NTSB ATL86LA232Accident · No injuriesLimited investigationFinal reportCessna 150H · Rome, GAThe plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…Aug 29, 1986 · N22144 · Substantial damage NTSB ATL84LA181Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jessup, GAThe acft landed off the rwy during a forced landing following a power loss. Wx conditions were conducive to carburetor icing.May 20, 1984 · N22815 · Substantial damage NTSB ATL83FA179Accident · 2 fatalField investigationFinal reportCessna C-150H · Fort Valley, GAAfter a touch-and-go landing, the aircraft was observed to turn after takeoff, enter a steep climp, then go into a steep nose down descent & crash. Witnesses reported hearing the eng operating until just prior to impact. An exam of the acft & eng revealed no…May 7, 1983 · N7146S · Destroyed NTSB ATL80FKG10Accident · No injuriesClosedCessna 150H · Stockbridge, GAJul 17, 1980 · N6581S · Substantial damage NTSB MIA78FKG23Accident · Minor injuriesClosedCessna 150 · Lawrenceville, GAMar 5, 1978 · N50196 · Substantial damage NTSB MIA76DKG89Accident · No injuriesClosedCessna 150 · Gainesville, GAJul 27, 1976 · N22626 · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 150H · Carrollton, GASep 18, 1974 · N22514 · Substantial damage NTSB MIA74DKG03Accident · No injuriesClosedCessna 150 · Swainsboro, GAJul 7, 1973 · N22558 · Substantial damage NTSB MIA73FKG50Accident · Minor injuriesClosedCessna 150H · Reidsville, GADec 2, 1972 · N6982S · Substantial damage NTSB MIA73DKG42Accident · No injuriesClosedCessna 150H · Canton, GAOct 11, 1972 · N23486 · Substantial damage NTSB MIA72DKH25Accident · No injuriesClosedCessna 150 · St Marys, GAJun 30, 1972 · N23304 · Substantial damage NTSB MIA71DKG23Accident · No injuriesClosedCessna 150 · Winston, GAJul 26, 1970 · N23073 · Substantial damage NTSB MIA70DKG10Accident · No injuriesClosedCessna 150H · Pine Mountain, GAFeb 7, 1970 · N22638 · Substantial damage NTSB MIA69D0161Accident · No injuriesClosedCessna 150 · Valdosta, GAAug 9, 1968 · N6529S · Destroyed