Skip to content

NTSB investigations: Cessna 150H, TN

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

19682026

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 ('2071818')) 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 ('2071818'))
  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 ('2071818'))
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 ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Dec 26, 2011 · N22565 · Substantial damage NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.Mar 20, 2011 · N6555S · Substantial damage NTSB ERA11LA149Accident · No injuriesLimited investigationFinal reportCessna 150H · Jonesborough, TNA partial loss of engine power during initial climb for undetermined reasons.Feb 17, 2011 · N7237S · Substantial damage NTSB ATL07CA071Accident · No injuriesData collectionFinal reportCessna C-150H · Dyersburg, TNThe student's pilot's misjudged distance/altitude that led to an undershoot and a failure to attain the proper touchdown point.Apr 8, 2007 · N6555S · Substantial damage NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.May 9, 2001 · N6614S · Substantial damage NTSB MIA00LA100Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Dandridge, TNthe student pilot's improper preflight that resulted in his operating an aircraft with contaminated fuel that resulted in a loss of engine power and a forced landing in the trees and damage to the aircraft. Contributing to the accident were the student's…Feb 28, 2000 · N6753S · Substantial damage NTSB ATL96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Knoxville, TNFailure of the pilot to maintain sufficient airspeed during a go-around, which resulted in a stall.Jan 28, 1996 · N50215 · Substantial damage NTSB ATL95LA034Accident · No injuriesLimited investigationFinal reportCessna 150H · Fayetteville, TNThe pilot's improper use of carburetor heat.Jan 4, 1995 · N7185S · Substantial damage NTSB ATL91LA021Accident · No injuriesLimited investigationFinal reportCessna 150 · Arlington, TNThe student pilot's failure to maintain directional control during landing. A factor in this accident was gusty winds.Nov 24, 1990 · N7234S · Substantial damage NTSB IAD77FLT06Accident · Serious injuriesClosedCessna 150H · Millington, TNAug 24, 1977 · N23321 · Destroyed NTSB IAD76FKW34Accident · Serious injuriesClosedCessna 150 · Murfreesboro, TNJun 17, 1976 · N50196 · Destroyed NTSB IAD76FLT03Accident · No injuriesClosedCessna 150H · Arlington, TNAug 12, 1975 · N7082S · Substantial damage NTSB IAD74FLT13Accident · No injuriesClosedCessna 150H · Memphis, TNJan 27, 1974 · N23321 · Substantial damage NTSB MIA73AM067Accident · 2 fatalClosedCessna 150H · Beechgrove, TNDec 25, 1972 · N22545 · Destroyed NTSB MIA72FKW16Accident · No injuriesClosedCessna 150H · Nashville, TNFeb 4, 1972 · N50299 · Substantial damage NTSB MIA71FKW44Accident · No injuriesClosedCessna 150 · Murfreesboro, TNApr 5, 1971 · N22651 · Substantial damage NTSB MIA71DKW36Accident · No injuriesClosedCessna 150 · Murfreesboro, TNFeb 20, 1971 · N7019S · Substantial damage NTSB MIA71DKW38Accident · No injuriesClosedCessna 150 · Murfreesboro, TNFeb 18, 1971 · N22651 · Substantial damage NTSB MIA70D0124Accident · No injuriesClosedCessna 150 · Murfreesboro, TNSep 6, 1969 · N23362 · Substantial damage NTSB MIA69F0439Accident · No injuriesClosedCessna 150 · Wrigley, TNApr 20, 1969 · N7186S · Substantial damage NTSB MIA69D0091Accident · No injuriesClosedCessna 150 · Lebanon, TNAug 22, 1968 · N50284 · Substantial damage NTSB MIA68F0441Accident · No injuriesClosedCessna 150 · Murfreesboro, TNMar 30, 1968 · N7019S · Substantial damage