Skip to content

NTSB investigations: Cessna 150L, IN

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

19742026

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" = 'IN' 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 ('2071826')) 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\" = 'IN' 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 ('2071826'))
  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" = 'IN' 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 ('2071826'))
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 CEN15LA451Accident · No injuriesLimited investigationFinal reportCessna 150L · Carthage, INThe partial loss of engine power due to carburetor icing.Jun 20, 2015 · N17292 · Substantial damage NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.Jan 11, 2009 · N778ME · Substantial damage NTSB CHI04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Corydon, INThe student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…Jan 17, 2004 · N17254 · Substantial damage NTSB CHI01LA170Accident · No injuriesLimited investigationFinal reportCessna 150L · Munster, INEngine failure during takeoff due to water contaminating the fuel, the pilot's inadequate preflight planning/preparation, and the low altitude. Factors relating to this accident were the attempted emergency landing after takeoff and the fence.Jun 17, 2001 · N6557G · Substantial damage NTSB CHI00LA183Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INthe failure of the pilot to maintain clearance from the building during taxi.Jun 29, 2000 · N11527 · Substantial damage NTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…Aug 20, 1999 · N161BA · Substantial damage NTSB CHI96LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Wabash, INdeer that went onto the runway as the aircraft was landing. The light condition at dusk was a related factor.Nov 5, 1995 · N21960 · Substantial damage NTSB CHI94LA178Accident · 1 fatalLimited investigationFinal reportCessna 150L · Richmond, INInadequate visual lookout by the pilots of both airplanes.May 28, 1994 · N153KA · 2 aircraft · Destroyed NTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.Jun 11, 1992 · N21906 · Substantial damage NTSB CHI91LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Greenfield, INA stall/spin encountered due to an improper go-around.Oct 28, 1990 · N19168 · Substantial damage NTSB CHI89LA059Accident · No injuriesLimited investigationFinal reportCessna 150L · Sellersburg, INThe failure of the student pilot to control the airplane during the landing flare and touchdown. The student pilots lack of experience and gusty crosswinds are contributing factors to the accident.Mar 22, 1989 · N5228Q · Substantial damage NTSB CHI85FA300Accident · 2 fatalField investigationFinal reportCessna 150L · Bainbridge, INThe acft was observed at about 300 ft AGL. It had just completed a turn with its wings level when it suddenly nosed over and entered a spin to ground impact.Jul 18, 1985 · N19293 · Destroyed NTSB CHI85LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Griffith, INOn the student's third approach, he was observed to flare the acft too high. The acft drifted off to the side of the rwy and nosed down until it collided with the ground.Jun 22, 1985 · N10239 · Substantial damage NTSB CHI85LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, INThe non-instrument rated plt made a forced landing in a muddy fld due to a low fuel state and IFR conditions. The acft nosed over upon touchdown. There was no record found of the plt having received a wx briefing.Mar 2, 1985 · N36TD · Substantial damage NTSB CHI85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Central, INThe acft contacted a tree and nosed over during a forced landing following fuel exhaustion. The student plt was observed by several witnesses to to remove the fuel caps during preflight and check the fuel quantity. The plt stated the fuel level was up to the…Jan 12, 1985 · N10543 · Substantial damage NTSB CHI82FET01Accident · No injuriesClosedCessna 150 · Ft Wayne, INOct 7, 1981 · N7688G · Substantial damage NTSB CHI81FET02Accident · No injuriesClosedCessna 150 · Griffin, INNov 1, 1980 · N1744Q · Substantial damage NTSB CHI79DET01Accident · No injuriesClosedCessna 150 · Peru, INOct 18, 1978 · N19043 · Substantial damage NTSB CHI77FEX17Accident · Minor injuriesClosedCessna 150 · Helmsburg, INMar 19, 1977 · N6TA · Substantial damage NTSB CHI76FEA48Accident · No injuriesClosedCessna 150L · Greenwood, INAug 21, 1976 · N6956G · Substantial damage NTSB CHI76FEA43Accident · No injuriesClosedCessna 150 · Charlestown, INJun 9, 1976 · N18171 · Substantial damage NTSB CHI76FEA30Accident · No injuriesClosedCessna 150L · Bloomington, INApr 27, 1976 · N19318 · Substantial damage NTSB CHI76FET26Accident · No injuriesClosedCessna 150L · Goshen, INFeb 7, 1976 · N19209 · Substantial damage NTSB CHI76FET18Accident · No injuriesClosedCessna 150L · Schneider, INOct 10, 1975 · N6818G · Substantial damage NTSB CHI76FET09Accident · Serious injuriesClosedCessna 150L · New Elliott, INAug 21, 1975 · N66014 · Substantial damage NTSB CHI75DEA22Accident · No injuriesClosedCessna 150 · Indianapolis, INJun 5, 1975 · N21923 · Substantial damage NTSB CHI75DEA20Accident · No injuriesClosedCessna 150 · Jeffersonville, INApr 4, 1975 · N5228Q · Substantial damage NTSB CHI74FEA39Accident · No injuriesClosedCessna 150L · Lebanon, INMay 20, 1974 · N10795 · Substantial damage