Skip to content

NTSB investigations: Cessna 150M, GA

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

19762026

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 ('2071830')) 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 ('2071830'))
  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 ('2071830'))
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 ERA17LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Homerville, GAA total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.May 9, 2017 · N714DW · Substantial damage NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.Aug 5, 2015 · N3568V · Substantial damage NTSB ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.Apr 14, 2012 · N714JJ · Substantial damage NTSB MIA99LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150M · La Fayette, GAThe improper flare by the student pilot and the inadequate supervision by the pilot in command.Jun 4, 1999 · N3773V · Substantial damage NTSB ATL98LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Athens, GAThe student pilot's failure to maintain directional control during land roll out that resulted in the on ground collision.Aug 24, 1998 · N704HU · Substantial damage NTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.Nov 24, 1987 · N4081V · Substantial damage NTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…May 26, 1987 · N704YK · Substantial damage NTSB ATL86FA259Accident · 2 fatalField investigationFinal reportCessna 150M · Screven, GAThe plt and his best man for his wedding scheduled for later in the day dep LCL apt early in the am. The acft was observed maneuvering at a low alt over the plts parents home. Witnesses described the maneuvers to be like a crop duster making pull ups and…Sep 20, 1986 · N66297 · Destroyed NTSB ATL83FKG03Accident · Minor injuriesFinal reportCessna 150M · Stone Mountain, GAThe pilot reported that while flying in marginal weather, he came to Stone Mountain and turned to avoid it. The aircraft crashed on the side of the Mountain about 300 ft from the base. About 9 mi east southeast of the crash site, the weather was reported as…Nov 28, 1982 · N66103 · Substantial damage NTSB ATL82FKG16Accident · No injuriesFinal reportCessna 150M · Madison, GAAfter touchdown the tailwheel equipped C-150 veered off the rwy into a gully breaking off the tailwheel. The acft then struck an embankment.Aug 20, 1982 · N9336U · Substantial damage NTSB ATL80FKG26Accident · Minor injuriesClosedCessna 150 · Covington, GASep 15, 1980 · N2934V · Destroyed NTSB MIA80FKG18Accident · No injuriesClosedCessna 150 · Columbus, GAFeb 18, 1980 · N45384 · Destroyed NTSB MIA79FKG33Accident · 1 fatalClosedCessna 150 · Hawkinsville, GAApr 21, 1979 · N66550 · No damage NTSB MIA78DLA20Accident · No injuriesClosedCessna 150M · Bainbridge, GAMar 16, 1978 · N6169K · Substantial damage NTSB MIA78FKG16Accident · No injuriesClosedCessna 150 · Norcross, GAJan 27, 1978 · N63271 · Substantial damage NTSB MIA78FKG12Accident · Serious injuriesClosedCessna 150 · Newman, GAJan 16, 1978 · N63330 · Substantial damage NTSB MIA78FLA08Accident · No injuriesClosedCessna 150 · Thomasville, GADec 2, 1977 · N704HX · Destroyed NTSB MIA77FKG23Accident · Serious injuriesClosedCessna 150 · Atlanta, GAApr 14, 1977 · N3489V · Minor damage NTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damage NTSB MIA76DKG43Accident · No injuriesClosedCessna 150M · Chamblee, GAFeb 21, 1976 · N3104V · Substantial damage