Skip to content

NTSB investigations: Cessna 150G, TN

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

19672026

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 ('2071816')) 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 ('2071816'))
  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 ('2071816'))
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 ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.Jan 8, 2022 · N1308U · 2 aircraft · Substantial damage NTSB ERA10CA324Accident · No injuriesData collectionFinal reportCessna 150G · Jasper, TNThe pilot under instruction's failure to maintain directional control during landing, and his failure to relinquish the flight controls when directed.Jun 21, 2010 · N8321J · Substantial damage NTSB ATL01FA059Accident · 1 fatalField investigationFinal reportCessna 150 G · Dunlap, TNThe pilot's failure to maintain flying speed that resulted in a stall and subsequent loss of control in flight.May 12, 2001 · N3370J · Destroyed NTSB MIA99LA218Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greeneville, TNThe pilot's failure to remain clear of clouds while operating under visual flight rules resulting in the aircraft colliding with trees on rising terrain as he flew in the clouds.Aug 9, 1999 · N3187X · Substantial damage NTSB ATL93LA017Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TNThe water in the aircraft fuel as a result of the improper preflight by the pilot.Oct 23, 1992 · N3366J · Substantial damage NTSB ATL92LA099Accident · 1 fatalLimited investigationFinal reportCessna 150G · Samburg, TNThe pilot's poor judgement in that he attempted aerobatic maneuvers at an altitude that was too low to recover from the maneuver.May 9, 1992 · N2494J · Substantial damage NTSB ATL91LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Copperhill, TNThe pilot's improper use of carburetor heat. A factor in the accident was the existing of carburetor icing conditions.Apr 24, 1991 · N2409J · Substantial damage NTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…Mar 17, 1986 · N2618J · Substantial damage NTSB IAD79FKW01Accident · 2 fatalClosedCessna 150G · Evensville, TNOct 28, 1978 · N3637J · Destroyed NTSB IAD75FKW19Accident · No injuriesClosedCessna 150 · Crossville, TNJun 16, 1975 · N2676J · Substantial damage NTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damage NTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damage NTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damage NTSB MIA73DLT01Accident · Serious injuriesClosedCessna 150 · Milan, TNJul 14, 1972 · N2940J · Substantial damage NTSB MIA72DKW25Accident · No injuriesClosedCessna 150G · Rogersville, TNApr 29, 1972 · N8595J · Substantial damage NTSB MIA71FKW29Accident · No injuriesClosedCessna 150 · Nashville, TNJan 3, 1971 · N3212X · Substantial damage NTSB MIA71DKW22Accident · No injuriesClosedCessna 150 · Whitwell, TNNov 9, 1970 · N3211X · Substantial damage NTSB MIA71FKW16Accident · No injuriesClosedCessna 150 · Lafollette, TNOct 25, 1970 · N3644J · Substantial damage NTSB MIA70D0234Accident · No injuriesClosedCessna 150G · Cookeville, TNNov 30, 1969 · N6307S · Substantial damage NTSB MIA70F0135Accident · No injuriesClosedCessna 150 · Knoxville, TNSep 20, 1969 · N3262J · Substantial damage NTSB MIA69F0308Accident · No injuriesClosedCessna 150 · Gallatin, TNDec 14, 1968 · N8349J · Substantial damage NTSB MIA69A0025Accident · 1 fatalClosedCessna 150G · Fayetteville, TNNov 4, 1968 · N8501J · Destroyed NTSB MIA68F0525Accident · No injuriesClosedCessna 150 · Donelson, TNJun 7, 1968 · N2996J · Substantial damage NTSB MIA68F0144Accident · No injuriesClosedCessna 150G · Centerville, TNSep 16, 1967 · N8349J · Substantial damage NTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNJul 29, 1967 · N2938S · Substantial damage