Skip to content

NTSB investigations: Cessna 150K, GA

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

19712026

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 ('2071822')) 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 ('2071822'))
  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 ('2071822'))
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 ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.Apr 27, 2009 · N6213G · Substantial damage NTSB ATL04LA110Accident · No injuriesLimited investigationFinal reportCessna 150K · Monticello, GAThe pilot's failure to maintain clearance from trees during taxi from landing.Apr 29, 2004 · N5656G · Substantial damage NTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.Jan 3, 2003 · N6098G · Substantial damage NTSB MIA97LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Ball Ground, GAfailure of the pilot to maintain directional control during the takeoff roll and his failure to abort the takeoff before colliding with an embankment.May 16, 1997 · N5689G · Substantial damage NTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.Jul 16, 1994 · N6074G · Substantial damage NTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.Nov 12, 1993 · N6461G · Substantial damage NTSB ATL85LA229Accident · No injuriesLimited investigationFinal reportCessna 150K · Orchard Hill, GAThe acft suffered a loss of pwr due to fuel exhaustion and the plt made an emergency landing in a fld. During landing roll the acft collided with trees at the end of the fld. Post accident exam of the acft revealed one gallon of fuel in the right fuel tank…Aug 2, 1985 · N5773G · Substantial damage NTSB ATL83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Kennesaw, GAThe acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a…May 7, 1983 · N5835G · Substantial damage NTSB MIA78FKG36Accident · No injuriesClosedCessna 150 · Covington, GAApr 7, 1978 · N6489G · Substantial damage NTSB MIA76FKG55Accident · No injuriesClosedCessna 150K · Fayetteville, GAApr 19, 1976 · N6489G · Substantial damage NTSB MIA75FKG78Accident · No injuriesClosedCessna 150K · Ellaville, GAJun 13, 1975 · N5720G · Substantial damage NTSB MIA75FKG75Accident · No injuriesClosedCessna 150 · Sparta, GAJun 1, 1975 · N6204G · Substantial damage NTSB MIA73FKG75Accident · Serious injuriesClosedCessna 150 · Chamblee, GAMay 6, 1973 · N5834G · Substantial damage NTSB MIA72FKG93Accident · No injuriesClosedCessna 150 · Lithonia, GAApr 25, 1972 · N5720G · Substantial damage NTSB MIA72FKG12Accident · No injuriesClosedCessna 150K · Talbotton, GAJul 24, 1971 · N5959G · Destroyed