Skip to content

NTSB investigations: Cessna 150F, OK

39 cases on aircraft the registry lists as Cessna 150F. 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" = 'OK' 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 ('2071814')) 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\" = 'OK' 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 ('2071814'))
  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" = 'OK' 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 ('2071814'))
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 CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.Mar 25, 2022 · N6714F · Substantial damage NTSB CEN16LA184Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ponca City, OKMaintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.May 1, 2016 · N8619G · Substantial damage NTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Sep 4, 2000 · N8783S · Substantial damage NTSB FTW99LA272Accident · 1 fatalLimited investigationFinal reportCessna 150F · Poteau, OKThe instructor pilot's inadequate in-flight decision making, which resulted in the continued flight with a disabled generator and subsequent total failure of the electrical system. Factors were the installation of the inadequate generator fuse by unknown…Oct 1, 1999 · N8092S · Substantial damage NTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.Apr 21, 1998 · N8720G · Destroyed NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.Apr 21, 1997 · N3101X · Substantial damage NTSB FTW95LA107Accident · No injuriesLimited investigationFinal reportCessna 150F · Commerce, OKFuel exhaustion as a result of the pilot failing to perform an adequate preflight inspection of the airplane. The lack of suitable terrain on which to make a forced landing was a factor.Feb 5, 1995 · N8732S · Substantial damage NTSB FTW88DPJ11Accident · No injuriesFinal reportCessna 150F · Oklahoma City, OKThe student pilot had just returned to flying after an extended time. During the approach he failed to add carburetor heat and the engine failed when power was added. Automotive fuel was being used in the aircraft but the STC had not been complied with.Aug 31, 1988 · N6474F · Substantial damage NTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…Sep 28, 1986 · N3578L · Substantial damage NTSB FTW86LPJ04Accident · No injuriesFinal reportCessna 150F · Tulsa, OKThe acft nosed over during a forced landing following a loss of pwr. The plt stated 'quite abit' of water was drained from the fuel system during preflight. Aprx 10 to 15 minutes after takeoff the eng began to sputter and eventually quit. The nose wheel…Dec 26, 1985 · N8535G · Substantial damage NTSB FTW84LA340Accident · No injuriesLimited investigationFinal reportCessna 150F · Walters, OKPlt took the acft without authorization and attempted a landing in an open field near his passenger's home. The terrain was soft and unsuitable for acft operations, acft right wing contacted the ground during lndg roll, damaging the wing attach point. Plt…Aug 6, 1984 · N6525F · Substantial damage NTSB FTW81FPJ27Accident · Minor injuriesClosedCessna 150 · Guthrie, OKJun 10, 1981 · N8070S · Destroyed NTSB FTW77FPM21Accident · Minor injuriesClosedCessna 150 · Tulsa, OKSep 4, 1977 · N6686F · Substantial damage NTSB FTW76DPM25Accident · Serious injuriesClosedCessna 150 · Chelsea, OKJun 3, 1976 · N3579L · No damage NTSB FTW76DPJ35Accident · No injuriesClosedCessna 150 · Clinton, OKMay 28, 1976 · N8054F · Substantial damage NTSB FTW75FPM19Accident · No injuriesClosedCessna 150F · Kansas, OKJun 21, 1975 · N3028X · Substantial damage NTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKDec 11, 1971 · N7025F · Destroyed NTSB FTW71DPJ28Incident · No injuriesClosedCessna 150 · Woodward, OKFeb 23, 1971 · N7126F · Minor damage NTSB FTW71DPJ26Accident · No injuriesClosedCessna 150 · East Jesse, OKJan 11, 1971 · N8284S · Substantial damage NTSB FTW70DPM04Accident · No injuriesClosedCessna 150F · Dewey, OKApr 19, 1970 · N8645S · Substantial damage NTSB FTW70DPJ04Accident · No injuriesClosedCessna 150 · Lawton, OKFeb 5, 1970 · N8051S · Substantial damage NTSB FTW70AF049Accident · No injuriesClosedPiper PA-23 · Tulsa, OKJan 23, 1970 · N6847Y · 2 aircraft · Substantial damage NTSB FTW69F0322Accident · Serious injuriesClosedCessna 150 · Calumet, OKNov 28, 1968 · N8265F · Substantial damage NTSB FTW69D0214Accident · No injuriesClosedCessna 150F · Hobart, OKOct 6, 1968 · N7709F · Substantial damage NTSB FTW69D0212Accident · No injuriesClosedCessna 150 · Altus, OKSep 25, 1968 · N6566F · Substantial damage NTSB FTW69D0168Accident · No injuriesClosedCessna 150 · Thomas, OKAug 26, 1968 · N7140F · Substantial damage NTSB FTW69F0069Accident · No injuriesClosedCessna 150 · Collinsville, OKJul 25, 1968 · N8326G · Substantial damage NTSB FTW68A0101Accident · No injuriesClosedCessna 337B · Norman, OKMay 30, 1968 · N2308S · 2 aircraft · Substantial damage NTSB FTW68F0333Accident · No injuriesClosedCessna 150 · Bethany, OKNov 11, 1967 · N8761S · Substantial damage NTSB FTW68A0047Accident · 2 fatalClosedCessna 150F · Elgin, OKNov 4, 1967 · N8683S · Destroyed NTSB FTW68D0222Accident · No injuriesClosedCessna 150F · Guymon, OKSep 10, 1967 · N6671F · Substantial damage NTSB FTW68F0098Accident · No injuriesClosedCessna 150F · Wynnewood, OKJul 25, 1967 · N8284S · Substantial damage NTSB FTW68D0012Accident · No injuriesClosedCessna 150F · Geronimo, OKJun 6, 1967 · N3579L · Destroyed NTSB FTW67D0511Accident · No injuriesClosedCessna 150 · Enid, OKMar 29, 1967 · N6457F · Substantial damage NTSB FTW67D0119Accident · No injuriesClosedCessna 150 · Erick, OKJul 30, 1966 · N8417G · Substantial damage NTSB FTW67D0072Accident · No injuriesClosedCessna 150 · Ardmore, OKJul 14, 1966 · N8191S · Substantial damage NTSB FTW67D0055Accident · No injuriesClosedCessna 150 · Waurtka, OKJul 5, 1966 · N8399G · Substantial damage NTSB FTW66D0603Accident · No injuriesClosedCessna 150 · Tulsa, OKMar 28, 1966 · N8872G · Substantial damage NTSB FTW66F0339Accident · No injuriesClosedCessna 150 · Oklahoma Cty, OKOct 9, 1965 · N8761S · Substantial damage