Skip to content

NTSB investigations: Cessna 150M, TN

26 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

19742026

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" = 'TN' 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\" = 'TN' 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" = 'TN' 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 ERA24LA087Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Hohenwald, TNThe pilot’s failure to use carburetor heat in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to fuel starvation. Contributing to the outcome was her failure to attain a proper touchdown point…Jan 10, 2024 · N7UT · Substantial damage NTSB ERA10CA372Accident · No injuriesData collectionFinal reportCessna 150M · Knoxville, TNThe student pilot's improper recovery from a bounced landing.Jul 22, 2010 · N45220 · Substantial damage NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.Sep 30, 2004 · N45667 · Substantial damage NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.Dec 1, 1999 · N704YE · Substantial damage NTSB MIA99LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chattanooga, TNThe failure of the student pilot to maintain directional control during the flare/touchdown.May 2, 1999 · N704RB · Substantial damage NTSB MIA98LA132Accident · No injuriesLimited investigationFinal reportCessna 150M · Gainesboro, TNThe student pilot's improper flare during landing.Apr 14, 1998 · N704HL · Substantial damage NTSB MIA97LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNthe student pilot's improper planning/decision, and his failure to maintain proper runway alignment during a crosswind landing. The strong crosswind was a related factor.Dec 8, 1996 · N714LF · Substantial damage NTSB ATL96LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TNthe failure of the pilot of the Cessna 150, N63434, to see and avoid the Cessna 152, N151FC.Feb 24, 1996 · N151FC · 2 aircraft · Substantial damage NTSB ATL93LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Smyrna, TNThe improper flare and the improper go around procedures used by the pilotJun 22, 1993 · N63255 · Substantial damage NTSB ATL92LA186Accident · No injuriesLimited investigationFinal reportCessna 150M · Nashville, TNThe student pilot's inadequate inflight planning, which resulted in fuel exhaustion. A factor was his geographical disorientation.Sep 29, 1992 · N7764U · Substantial damage NTSB ATL90LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNPilot's failure to maintain directional control upon landing and subsequent premature rotation of the airplane during the go-around attempt. Contributing to the accident was the pilot's lack of total experience.Jun 19, 1990 · N9348U · Substantial damage NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.Jun 17, 1989 · N714SR · Substantial damage NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…Oct 2, 1988 · N6176K · Substantial damage NTSB ATL86LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lake City, TNWhile filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft…Apr 18, 1986 · N63636 · Destroyed NTSB ATL86LLT01Accident · No injuriesFinal reportCessna 150 · Livingston, TNThe plt made a forced landing in rugged tree covered terrain following a loss of pwr due to fuel exhaustion while on a x-country flt. The plt decame lost near Livingston, TN, and contacted the crossville and london fss for assistance. The acft was located 5…Oct 9, 1985 · N714BZ · Substantial damage NTSB ATL81FLT13Accident · Serious injuriesClosedCessna 150 · Jackson, TNAug 15, 1981 · N9305U · Substantial damage NTSB IAD80FLT04Accident · Minor injuriesClosedCessna 150 · Jackson, TNJan 26, 1980 · N6364K · Substantial damage NTSB IAD80FKW01Accident · No injuriesClosedCessna 150 · Collegedale, TNOct 25, 1979 · N714BM · Substantial damage NTSB DCA78AA013Accident · 6 fatalClosedSud Avtn DA-20 · Memphis, TNMay 18, 1978 · N121GW · 2 aircraft · Destroyed NTSB IAD78DKW05Accident · No injuriesClosedCessna 150 · Philadelphia, TNMay 11, 1978 · N66560 · Substantial damage NTSB IAD78FA024Accident · Minor injuriesClosedCessna 150 · Arlington, TNDec 22, 1977 · N6431K · 2 aircraft · Substantial damage NTSB IAD78DKW03Accident · No injuriesClosedCessna 150 · Johnson City, TNOct 31, 1977 · N63074 · Substantial damage NTSB IAD77DKW23Accident · No injuriesClosedCessna 150 · Celina, TNJul 27, 1977 · N3155V · Substantial damage NTSB IAD77DKW19Accident · Minor injuriesClosedCessna 150 · Center Hill Lk, TNJun 11, 1977 · N6098K · Destroyed NTSB IAD76FLT08Accident · No injuriesClosedCessna 150 · Covington, TNApr 11, 1976 · N3400V · Substantial damage NTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNDec 19, 1974 · N2908V · Substantial damage