Skip to content

NTSB investigations: Cessna 150F, GA

46 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

19662026

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 ('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\" = '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 ('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" = '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 ('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 ERA17LA015Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stockbridge, GAA partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Oct 16, 2016 · N7948F · Substantial damage NTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.Feb 22, 2003 · N8115F · Substantial damage NTSB ATL88LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Newnan, GAAfter making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…Jun 14, 1988 · N7776F · Destroyed NTSB MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…Aug 25, 1984 · N25853 · 2 aircraft · Destroyed NTSB ATL82FKG03Accident · Minor injuriesClosedCessna 150F · Columbus, GAOct 28, 1981 · N8808G · Destroyed NTSB ATL80FLA04Accident · Serious injuriesClosedCessna 150 · Thomasville, GAMay 21, 1980 · N8029F · Destroyed NTSB MIA79DLA30Accident · Minor injuriesClosedCessna 150 · Mayday, GAJun 10, 1979 · N6577F · Substantial damage NTSB MIA78DKG34Accident · No injuriesClosedCessna C150 · Jenkinsburg, GAApr 3, 1978 · N8132F · Destroyed NTSB MIA78FA041Accident · 1 fatalClosedCessna 150F · Jefferson, GAFeb 15, 1978 · N8318G · Destroyed NTSB MIA77FKG56Accident · No injuriesClosedCessna 150F · Milledgeville, GAJul 27, 1977 · N8629G · Substantial damage NTSB MIA77DKG46Accident · No injuriesClosedCessna 150 · Peachtree City, GAJul 11, 1977 · N8255S · Substantial damage NTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GADec 24, 1976 · N7804F · Substantial damage NTSB MIA75DKG72Accident · No injuriesClosedCessna 150 · Rome, GAMay 19, 1975 · N8103S · Substantial damage NTSB MIA74DKG88Accident · No injuriesClosedCessna 150 · Toccoa, GAJun 2, 1973 · N8283S · Substantial damage NTSB MIA73FKG58Accident · No injuriesClosedCessna 150F · Alma, GAFeb 4, 1973 · N7017F · Substantial damage NTSB MIA73FKG44Accident · No injuriesClosedCessna 150 · Atlanta, GAOct 16, 1972 · N7075F · Substantial damage NTSB MIA73DKG25Accident · No injuriesClosedCessna 150 · Hortense, GAAug 13, 1972 · N8715S · Substantial damage NTSB MIA73DKG06Accident · No injuriesClosedCessna 150 · Butler, GAJul 20, 1972 · N8308G · Substantial damage NTSB MIA72FKH16Accident · No injuriesClosedCessna 150F · Pembroke, GAJun 17, 1972 · N8056S · Substantial damage NTSB MIA72AM056Accident · 2 fatalClosedCessna 150F · Dalton, GADec 21, 1971 · N8014F · Destroyed NTSB MIA72DKG37Accident · Minor injuriesClosedCessna 150 · Thomaston, GASep 3, 1971 · N8800G · Substantial damage NTSB MIA72DKG02Accident · No injuriesClosedCessna 150F · Fort Benning, GAJul 3, 1971 · N6996F · Substantial damage NTSB MIA71DKG39Accident · No injuriesClosedCessna 150F · Warner Robins, GASep 18, 1970 · N6809F · Substantial damage NTSB MIA71FKG35Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 5, 1970 · N8057S · Substantial damage NTSB MIA71FKG03Accident · No injuriesClosedCessna 150F · Atlanta, GAJul 8, 1970 · N8121F · Substantial damage NTSB MIA70DKG30Accident · No injuriesClosedCessna 150 · Douglasville, GAMay 15, 1970 · N6823F · Substantial damage NTSB MIA70F0001Accident · Minor injuriesClosedCessna 150 · Valdosta, GAJun 6, 1969 · N8775G · Substantial damage NTSB MIA69A0032Accident · No injuriesClosedCessna 182K · Rome, GADec 20, 1968 · N2812R · 2 aircraft · Substantial damage NTSB MIA69F0356Accident · Serious injuriesClosedCessna 150F · Lithonia, GAOct 28, 1968 · N8217S · Destroyed NTSB MIA69D0056Accident · Minor injuriesClosedCessna 150 · Doerun, GAJul 7, 1968 · N8115S · Substantial damage NTSB MIA69D0085Accident · No injuriesClosedCessna 150 · Pinehurst, GAJun 23, 1968 · N8121F · Substantial damage NTSB MIA69D0262Accident · No injuriesClosedCessna 150F · Albany, GAJun 8, 1968 · N8267S · Substantial damage NTSB MIA69F0060Accident · No injuriesClosedCessna 150F · Fairburn, GAApr 19, 1968 · N6924F · Substantial damage NTSB MIA69D0057Accident · No injuriesClosedCessna 150 · Swainsboro, GAMar 10, 1968 · N8853S · Substantial damage NTSB MIA68D0285Accident · No injuriesClosedCessna 150 · Villa Rica, GANov 11, 1967 · N6254R · Substantial damage NTSB MIA68D0331Accident · No injuriesClosedCessna 150 · Lithonia, GAOct 28, 1967 · N8122S · Substantial damage NTSB MIA68D0356Accident · No injuriesClosedCessna 150 · Dahlonega, GAOct 22, 1967 · N8225F · Destroyed NTSB MIA68D0166Accident · Minor injuriesClosedCessna 150 · Villa Rica, GASep 1, 1967 · N8488G · Substantial damage NTSB MIA68F0183Accident · Serious injuriesClosedCessna 150 · Douglasville, GAJul 23, 1967 · N7007F · Substantial damage NTSB MIA68D0068Accident · No injuriesClosedCessna 150 · Brunswick, GAJun 25, 1967 · N6615F · Substantial damage NTSB MIA67D0036Accident · No injuriesClosedCessna 150 · Dublin, GAMay 15, 1967 · N8154S · Substantial damage NTSB MIA67D0540Accident · No injuriesClosedCessna 150 · Leary, GAApr 1, 1967 · N8775G · Substantial damage NTSB MIA67A0101Accident · 1 fatalClosedCessna 150F · Lawrenceville, GAMar 29, 1967 · N8821S · Destroyed NTSB MIA67D0455Accident · No injuriesClosedCessna 150 · Lithonia, GAFeb 23, 1967 · N8217S · Substantial damage NTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GAAug 28, 1966 · N6924F · Substantial damage NTSB MIA66D0540Accident · No injuriesClosedCessna 150 · Chamblee, GAMay 9, 1966 · N8821S · Substantial damage