Skip to content

NTSB investigations: Cessna 150L, KY

18 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

19752026

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" = 'KY' 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\" = 'KY' 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" = 'KY' 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 ERA24LA134Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Clay, KYThe pilot’s decision to attempt a VFR flight in instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment due to alcohol consumption.Mar 9, 2024 · N1703Q · Substantial damage NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.Nov 9, 1994 · N5483Q · Substantial damage NTSB BFO91LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Lexington, KYThe pilot's inadequate inflight decision causing fuel exhaustion.Oct 23, 1990 · N18539 · Substantial damage NTSB ATL87FA244Accident · 1 fatalField investigationFinal reportCessna 150L · Murray, KYPIC stated to friends he intended to execute a hammerhead stall after take off from a private grass strip. Airstrip owner observed acft make a low pass, pitch up vertically, and execute a hammerhead stall at about 450-500 feet AGL. There was insufficient…Aug 29, 1987 · N6795G · Substantial damage NTSB ATL86LA257Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Covington, KYThe plt landed at the airstrip on his fathers farm as the third stop of the day. He reported that during the attempted takeoff he hit a tree and stalled the acft. His student pilot certificate had been signed off for his first x-country flt the day prior to…Sep 13, 1986 · N10539 · Substantial damage NTSB ATL86LA195Accident · No injuriesLimited investigationFinal reportCessna 150L · Shelbyville, KYThe plt rented the acft without verifying the actual fuel onboard. He then flew to his pvt strip, 26 NM away, and gave 'several' pax hops. About 5 mins after takeoff for the flt to return the acft to the owner's field, the engine started running rough and…Jul 10, 1986 · N10949 · Substantial damage NTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…Aug 14, 1982 · N1410Q · Destroyed NTSB IAD80DLQ18Accident · Minor injuriesClosedCessna 150L · Bowling Green, KYMay 26, 1980 · N16178 · Destroyed NTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYFeb 24, 1980 · N1678Q · Destroyed NTSB IAD80FLQ02Accident · No injuriesClosedCessna 150L · Winchester, KYOct 1, 1979 · N19205 · Substantial damage NTSB IAD79FLQ20Accident · No injuriesClosedCessna 172 · Louisville, KYJul 17, 1979 · N18171 · Substantial damage NTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · Destroyed NTSB IAD78FLQ02Accident · Minor injuriesClosedCessna 150 · Owensboro, KYOct 15, 1977 · N19225 · Substantial damage NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB IAD76DLQ25Accident · No injuriesClosedCessna 150 · Hodgenville, KYJul 3, 1976 · N10660 · Substantial damage NTSB IAD76FLQ09Accident · No injuriesClosedCessna 150L · Olmstead, KYOct 13, 1975 · N1295Q · Substantial damage NTSB IAD76AI018Accident · 1 fatalClosedCessna 150L · Louisville, KYSep 30, 1975 · N5370Q · Destroyed NTSB IAD7KDLQ26Accident · No injuriesClosedCessna 150 · Versailles, KYMay 18, 1975 · N10770 · Substantial damage