Skip to content

NTSB investigations: Cessna 150E, TX

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

19652026

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 ('2071812')) 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 ('2071812'))
  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 ('2071812'))
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 CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.Jul 30, 2022 · N6212Y · Substantial damage NTSB CEN20LA133Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · McKinney, TXThe pilot's inadequate preflight fuel planning and inflight fuel management, which resulted in fuel exhaustion and a total loss of engine power.Mar 25, 2020 · N4729U · Substantial damage NTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.Aug 15, 2019 · N150CR · Substantial damage NTSB DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.Apr 29, 2007 · N2524J · Substantial damage NTSB SEA07CA100Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the lack of suitable terrain for the forced landing.Apr 20, 2007 · N3523J · Substantial damage NTSB FTW04CA122Accident · No injuriesData collectionFinal reportCessna 150E · Goldthwaite, TXThe pilot's inadequate in-flight planning and decision not to refuel, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the dark night conditions.May 3, 2004 · N3050J · Destroyed NTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.Nov 26, 2000 · N6521D · 2 aircraft · Substantial damage NTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.Dec 7, 1990 · N3956U · Destroyed NTSB FTW84LA355Accident · No injuriesLimited investigationFinal reportCessna 150E · Cleburne, TXPlt stated that while making a crosswind landing on a 2600 foot strip she misjudged her touchdown point and ran off the end of the strip, colliding with a fence. The plt landed on heading 350 degrees and the wind was reported to be from 090 degrees at 10…Jul 29, 1984 · N3055J · Substantial damage NTSB FTW82FPA12Accident · Serious injuriesFinal reportCessna 150 · Allen, TXA witness attending a horse show observed the acft fly over the field at low altitude in a slow flt & that something wrapped in plastic was dropped from the acft. The acft was in a nose high attitude approaching a stall. The acft then disappeared from his…Jun 13, 1982 · N3971U · Destroyed NTSB FTW77FPD39Accident · Serious injuriesClosedCessna 150 · Springtown, TXSep 12, 1977 · N6240T · Destroyed NTSB FTW77DPD21Accident · No injuriesClosedCessna 150 · Abilene, TXApr 24, 1977 · N3976U · Substantial damage NTSB FTW74FPA21Accident · No injuriesClosedCessna 150E · Sherman, TXApr 6, 1974 · N6105T · Substantial damage NTSB FTW74DRA26Accident · No injuriesClosedCessna 150E · Gilchrist, TXFeb 2, 1974 · N3971U · Substantial damage NTSB FTW73AF022Accident · 1 fatalClosedCessna 150E · Flatonia, TXDec 1, 1972 · N3034J · Destroyed NTSB FTW72FRA10Accident · No injuriesClosedCessna 150E · Pearland, TXSep 27, 1971 · N6211R · Substantial damage NTSB FTW71DRA07Accident · No injuriesClosedCessna 150 · Conroe, TXJul 25, 1970 · N6211R · Substantial damage NTSB FTW69A0070Accident · 1 fatalClosedCessna 150E · Placedo, TXApr 8, 1969 · N2555J · Destroyed NTSB FTW69F0400Accident · No injuriesClosedCessna 150E · Dallas, TXMar 13, 1969 · N4034U · Substantial damage NTSB FTW69D0449Accident · Minor injuriesClosedCessna 150E · Midland, TXMar 13, 1969 · N3038J · Substantial damage NTSB FTW69F0296Accident · No injuriesClosedCessna 150E · El Paso, TXNov 25, 1968 · N6228R · Substantial damage NTSB FTW69F0235Accident · Minor injuriesClosedCessna 150G · Beaumont, TXAug 28, 1968 · N2654J · 2 aircraft · Destroyed NTSB FTW68F0181Accident · Minor injuriesClosedCessna 150 · Dallas, TXJul 24, 1967 · N6268T · Substantial damage NTSB FTW68D0050Accident · No injuriesClosedCessna 150 · Palacios, TXMay 26, 1967 · N2591J · Substantial damage NTSB FTW67D0557Accident · No injuriesClosedCessna 150 · Houston, TXApr 13, 1967 · N3598J · Substantial damage NTSB FTW67F0506Accident · Minor injuriesClosedCessna 150E · Jacksboro, TXMar 21, 1967 · N4058U · Destroyed NTSB FTW67F0265Accident · No injuriesClosedCessna 150 · Houston, TXOct 26, 1966 · N6211R · Substantial damage NTSB FTW66D0621Accident · No injuriesClosedCessna 150 · Port Mansfild, TXApr 8, 1966 · N4083U · Substantial damage NTSB FTW66F0572Accident · Minor injuriesClosedCessna 150E · Pearland, TXMar 3, 1966 · N4098U · Substantial damage NTSB FTW66D0454Accident · No injuriesClosedCessna 150 · Bryan, TXDec 11, 1965 · N6243T · Substantial damage NTSB FTW66F0363Accident · No injuriesClosedCessna 150 · El Paso, TXNov 5, 1965 · N3039J · Substantial damage NTSB FTW66D0332Accident · No injuriesClosedCessna 150 · Austin, TXSep 1, 1965 · N2513J · Substantial damage NTSB FTW66F0186Accident · No injuriesClosedCessna 170 · El Paso, TXJul 25, 1965 · N6156T · Substantial damage NTSB FTW66F0153Accident · No injuriesClosedCessna 150 · Corpus Christi, TXJul 1, 1965 · N3951U · Substantial damage