Skip to content

NTSB investigations: Cessna 150, TX

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

19642026

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" = 'TX' 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 ('2071802')) 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\" = 'TX' 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 ('2071802'))
  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" = 'TX' 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 ('2071802'))
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 CEN23FA352Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Caddo Mills, TXThe pilot’s loss of airplane control during an attempted forced landing following a loss of engine power.Aug 7, 2023 · N5610E · Destroyed NTSB CEN13CA485Accident · No injuriesData collectionFinal reportCessna 150D · Hermleigh, TXThe pilot's improper positional awareness, which resulted in an off airport landing and impact with terrain.Aug 4, 2013 · N4281U · Substantial damage NTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.Jun 2, 1998 · N6486T · Substantial damage NTSB FTW91LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Cut And Shoot, TXThe total loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.Jul 29, 1991 · N5707E · Destroyed NTSB FTW91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Floresville, TXThe failure of the engine due to a jammed valve, incorrect maintenance procedures, and the pilot's improper compensation for the existing wind conditions. A factor was the tailwind.Mar 24, 1991 · N383VU · Substantial damage NTSB FTW89LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Terrell, TXThe pilot became lost during the flight and fuel exhaustion occurred which required an off airport forced landing.Aug 11, 1989 · N5794E · Substantial damage NTSB FTW84LA394Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Spicewood, TXDespite the existence of an airstrip across the street from his home, the plt elected to takeoff & land on the street. During the landing, the acft hit several trees & a pump house. Local law enforcement officers reported that the plt was drunk and drinking…Sep 14, 1984 · N7709E · Destroyed NTSB FTW83LA231Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wheeler, TXThe plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain…May 15, 1983 · N5525E · Substantial damage NTSB FTW78FRG62Accident · No injuriesClosedCessna 150 · Sandia, TXJul 15, 1978 · N5585E · Substantial damage NTSB FTW7MDQG39Accident · No injuriesClosedCessna 150 · Groom, TXJul 9, 1977 · N7880E · Substantial damage NTSB FTW77FA038Accident · 1 fatalClosedCessna 150 · Center, TXFeb 25, 1977 · N5669E · Destroyed NTSB FTW76FRA28Accident · Minor injuriesClosedCessna 150L · Pearland, TXApr 1, 1976 · N5306Q · Substantial damage NTSB FTW76FPD34Accident · No injuriesClosedCessna 150 · Arlington, TXMar 29, 1976 · N5779E · Substantial damage NTSB FTW75DPA28Accident · No injuriesClosedCessna 150 · Sulphur Spring, TXMay 18, 1975 · N5758E · Substantial damage NTSB FTW74FRG19Accident · No injuriesClosedCessna 150 · Portland, TXAug 31, 1973 · N5863E · Substantial damage NTSB FTW74FPD05Accident · No injuriesClosedCessna 150 · Grand Prairie, TXAug 11, 1973 · N5628E · Substantial damage NTSB FTW73AF074Accident · 2 fatalClosedCessna 150C · Waco, TXJun 24, 1973 · N6906G · Destroyed NTSB FTW73FPD18Accident · Serious injuriesClosedCessna 150 · Denton, TXJan 13, 1973 · N5518E · Substantial damage NTSB FTW70F0334Accident · Serious injuriesClosedCessna 150 · Lampasas, TXDec 9, 1969 · N5647E · Destroyed NTSB FTW69F0009Accident · No injuriesClosedCessna 150 · Keller, TXJun 15, 1969 · N5516E · Substantial damage NTSB FTW69D0283Accident · No injuriesClosedCessna 150 · Aransas Pass, TXOct 6, 1968 · N5678E · Substantial damage NTSB FTW67A0074Accident · 3 fatalClosedCessna 150 · Farwell, TXJan 11, 1967 · N8828G · Destroyed NTSB FTW67F0278Accident · No injuriesClosedCessna 150E · Killeen, TXOct 22, 1966 · N6233R · Substantial damage NTSB FTW67F0218Accident · Minor injuriesClosedCessna 150 · Presidio, TXSep 22, 1966 · N5855E · Destroyed NTSB FTW67D0093Accident · No injuriesClosedCessna 150 · Austin, TXJul 13, 1966 · N6421T · Substantial damage NTSB FTW67D0084Accident · No injuriesClosedCessna 150 · Blue Mound, TXJul 5, 1966 · N7896E · Substantial damage NTSB FTW66F0657Accident · No injuriesClosedCessna 150 · Dallas, TXMay 4, 1966 · N7941E · Substantial damage NTSB FTW66A0077Accident · 2 fatalClosedCessna 150 · Houston, TXMar 6, 1966 · N7927E · Destroyed NTSB FTW66F0438Accident · No injuriesClosedCessna 150 · Houston, TXDec 8, 1965 · N7860E · Substantial damage NTSB FTW66D0349Accident · No injuriesClosedCessna 150 · Portland, TXSep 14, 1965 · N5678E · Substantial damage NTSB FTW66F0196Accident · Minor injuriesClosedCessna 150 · El Paso, TXAug 9, 1965 · N5831E · Substantial damage NTSB FTW66D0115Accident · No injuriesClosedCessna 150 · Merit, TXJun 25, 1965 · N7762E · Substantial damage NTSB UNK65X1406Accident · Serious injuriesClosedCessna 150 · Pearland, TXFeb 7, 1965 · N7779E · Destroyed NTSB UNK65X1308Accident · No injuriesClosedCessna 150 · Fabens, TXJan 18, 1965 · N5576E · Substantial damage NTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · Destroyed NTSB UNK64X1301Accident · No injuriesClosedCessna 150 · Dallas, TXApr 13, 1964 · N5667E · Substantial damage NTSB UNK64X0961Accident · No injuriesClosedCessna 150 · Pearland, TXMar 17, 1964 · N5864E · Substantial damage