Skip to content

NTSB investigations: Cessna 150J, GA

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

19692026

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 ('2071820')) 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 ('2071820'))
  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 ('2071820'))
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 ERA12LA186Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Jasper, GAThe pilots' inadequate preflight inspection that failed to detect water-contaminated fuel, which resulted in a total loss of engine power.Feb 17, 2012 · N60276 · Substantial damage NTSB MIA08CA047Accident · No injuriesData collectionFinal reportCessna 150J · Dawson, GAThe pilot's failure to maintain directional control during landing roll out.Jan 28, 2008 · N51367 · Substantial damage NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.Aug 15, 2002 · N5603G · Destroyed NTSB ATL00LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Waycross, GAThe student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.Apr 22, 2000 · N60763 · Substantial damage NTSB ATL91FA150Accident · Serious injuriesField investigationFinal reportCessna 150J · Jonesboro, GAThe pilot's improper in-flight decision when he landed downwind, and beyond the proper touchdown point. Additionally, he failed to attain a safe climb speed, which resulted in a stall/spin. A factor was the high density altitude.Aug 3, 1991 · N60077 · Substantial damage NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.Jun 15, 1991 · N60466 · Substantial damage NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…Mar 19, 1988 · N60586 · Substantial damage NTSB ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…Nov 8, 1985 · N51182 · Substantial damage NTSB MIA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Coolidge, GAThe acft collided with a bush during landing. The plt flew under a wire that he saw just in time to avoid hitting and over the 5 foot embankment on the opposite side of an intervening roadway. After the collision, the acft flipped over and slid through a…Oct 15, 1984 · N60960 · Substantial damage NTSB ATL83LA304Accident · No injuriesLimited investigationFinal reportCessna 150J · Monroe, GAAfter turning final approach the pilot realized he was high so he lowered full flaps. Shortly thereafter he saw that the indicated airspeed was low and made an aircraft attitude adjustment. After he corrected for the low air speed he failed to rotate to a…Jul 29, 1983 · N61313 · Substantial damage NTSB MIA79DLA52Accident · Serious injuriesClosedCessna 150 · Brunswick, GASep 7, 1979 · N5603G · No damage NTSB MIA79DLA41Accident · No injuriesClosedCessna 150 · Camilla, GAJul 27, 1979 · N50635 · Substantial damage NTSB MIA79FKG06Accident · No injuriesClosedCessna 150 · Madison, GAOct 18, 1978 · N60791 · Substantial damage NTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GAJul 22, 1978 · N60746 · Substantial damage NTSB MIA77FKG28Accident · No injuriesClosedCessna 150 · Fitzgerald, GAMay 3, 1977 · N60521 · Substantial damage NTSB MIA77FKG21Accident · No injuriesClosedCessna 150J · Savannah, GAMar 5, 1977 · N5566G · Substantial damage NTSB MIA76FKG41Accident · No injuriesClosedCessna 150J · Tifton, GAFeb 4, 1976 · N50886 · Substantial damage NTSB MIA75FKG12Accident · No injuriesClosedCessna 150J · Baxley, GAJul 31, 1974 · N60549 · Substantial damage NTSB MIA73FKG62Accident · No injuriesClosedCessna 150J · Hampton, GAFeb 20, 1973 · N60728 · Destroyed NTSB MIA73FKG49Accident · Minor injuriesClosedCessna 150J · Hartwell, GANov 27, 1972 · N50572 · Destroyed NTSB MIA72FKG80Accident · Minor injuriesClosedCessna 150J · Chamblee, GAMar 12, 1972 · N60556 · Substantial damage NTSB MIA71FKG98Accident · No injuriesClosedCessna 150 · Stone Mtn, GAJun 26, 1971 · N60729 · Substantial damage NTSB MIA71DKG85Accident · No injuriesClosedCessna 150 · Covington, GAMay 22, 1971 · N61134 · Substantial damage NTSB MIA71DKG50Accident · No injuriesClosedCessna 150J · Suwanee, GANov 26, 1970 · N60228 · Substantial damage NTSB MIA71DKG40Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 18, 1970 · N60344 · Substantial damage NTSB MIA70DKG49Accident · No injuriesClosedCessna 150 · Dahlonega, GAJun 28, 1970 · N51367 · Substantial damage NTSB MIA70F0209Accident · No injuriesClosedCessna 150 · Dahlonega, GAJun 28, 1969 · N60344 · Substantial damage NTSB MIA69F0393Accident · No injuriesClosedCessna 150J · Chamblee, GAMar 19, 1969 · N50721 · Substantial damage NTSB MIA69F0413Accident · No injuriesClosedCessna 150J · Alpharetta, GAFeb 13, 1969 · N51143 · Substantial damage