Skip to content

NTSB investigations: Cessna 150F, LA

34 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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 CEN17FA281Accident · 1 fatalField investigationFinal reportCessna 150F · Farmerville, LAThe pilot's failure to maintain clearance from the lake during a low-level maneuver.Jul 23, 2017 · N8661S · Substantial damage NTSB CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.Oct 10, 2009 · N8642S · 2 aircraft · Substantial damage NTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.May 24, 2005 · N8120K · 2 aircraft · Substantial damage NTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.Aug 22, 1999 · N6243R · Substantial damage NTSB FTW96FA368Accident · 2 fatalField investigationFinal reportCessna 150F · Jones, LAVFR flight into instrument meteorological conditions (VMC), and failure of the pilot (PIC) to maintain control of the airplane after becoming spatially disorientation. Factors relating to the accident were: darkness, the adverse weather condition (fog and…Sep 2, 1996 · N8380G · Destroyed NTSB FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.Nov 24, 1987 · N6463F · Substantial damage NTSB FTW80FRD43Accident · No injuriesClosedCessna 150F · Mamou, LAJun 20, 1980 · N8109F · Substantial damage NTSB FTW79FRD12Accident · No injuriesClosedCessna 150 · Mamou, LAJan 6, 1979 · N8275F · Substantial damage NTSB FTW76FRJ12Accident · Serious injuriesClosedCessna 150F · Oil City, LANov 18, 1975 · N7116F · Substantial damage NTSB FTW73AF021Accident · 1 fatalClosedCessna 150F · New Orleans, LANov 30, 1972 · N6958F · Destroyed NTSB FTW70DRD19Accident · No injuriesClosedCessna 150 · Crowley, LAApr 10, 1970 · N7148C · Substantial damage NTSB FTW70DRJ04Accident · No injuriesClosedCessna 150 · Rayville, LAMar 18, 1970 · N8788G · Substantial damage NTSB FTW70D0084Accident · No injuriesClosedCessna 150 · Natchitoches, LAMay 28, 1969 · N8631S · Substantial damage NTSB FTW69F0326Accident · No injuriesClosedCessna 150F · New Orleans, LADec 14, 1968 · N3521L · Substantial damage NTSB FTW69F0306Accident · No injuriesClosedCessna 150F · Alexandria, LANov 23, 1968 · N8092S · Substantial damage NTSB FTW68D0580Accident · No injuriesClosedCessna 150 · Baton Rouge, LAMay 4, 1968 · N6405F · Substantial damage NTSB FTW68F0551Accident · No injuriesClosedCessna 150 · New Orleans, LAApr 14, 1968 · N6650F · Substantial damage NTSB FTW68F0400Accident · No injuriesClosedCessna 15OF · Alexandria, LADec 18, 1967 · N8697S · Substantial damage NTSB FTW68D0284Accident · No injuriesClosedCessna 150 · Baton Rouge, LAOct 17, 1967 · N6569F · Substantial damage NTSB FTW68F0240Accident · No injuriesClosedCessna 150 · Westwego, LASep 24, 1967 · N8459G · Substantial damage NTSB FTW68F0176Accident · No injuriesClosedCessna 150 · New Orleans, LAAug 23, 1967 · N6650F · Substantial damage NTSB FTW68D0030Accident · No injuriesClosedCessna 150 · New Orleans, LAJul 8, 1967 · N6691F · Substantial damage NTSB FTW67F0019Accident · No injuriesClosedCessna 150 · Houma, LAJun 19, 1967 · N7150F · Substantial damage NTSB FTW67F1004Accident · Serious injuriesClosedCessna 150 · Kentwood, LAApr 30, 1967 · N7710F · Destroyed NTSB FTW67D0528Accident · No injuriesClosedCessna 150 · Lafayette, LAApr 1, 1967 · N8918S · Substantial damage NTSB FTW67F0445Accident · No injuriesClosedCessna 150 · Lafayette, LAFeb 14, 1967 · N8918S · Substantial damage NTSB FTW67D0192Accident · Minor injuriesClosedCessna 150 · Slaughter, LASep 1, 1966 · N6585F · Substantial damage NTSB FTW67D0138Accident · No injuriesClosedCessna 150 · Freemason Isle, LAAug 16, 1966 · N8459G · Substantial damage NTSB FTW67F0096Accident · No injuriesClosedCessna 150F · Bogalusa, LAJul 16, 1966 · N8457G · Substantial damage NTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LAJun 25, 1966 · N8036S · Substantial damage NTSB FTW66D0650Accident · Minor injuriesClosedCessna 150 · Hammod, LAMay 1, 1966 · N6595F · Destroyed NTSB FTW66F0556Accident · No injuriesClosedCessna 150 · New Orleans, LAMar 15, 1966 · N8504G · Destroyed NTSB FTW66D0549Accident · No injuriesClosedCessna 150 · Slidell, LAMar 1, 1966 · N3521L · Substantial damage NTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LADec 12, 1965 · N8897S · Substantial damage