Skip to content

NTSB investigations: Cessna 150J, KS

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

19692026

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" = 'KS' 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 ('2071820')) 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\" = 'KS' 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 ('2071820'))
  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" = 'KS' 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 ('2071820'))
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 GAA18CA124Accident · No injuriesData collectionFinal reportCessna 150 · El Dorado, KSThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport landing and nose-over.Feb 4, 2018 · N61024 · Substantial damage NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.Mar 22, 2004 · N51365 · Substantial damage NTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Aug 14, 1996 · N61094 · Substantial damage NTSB MKC90LA122Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salina, KSInadvertent flight from VFR into IMC by the pilot in command.Jun 9, 1990 · N50820 · Substantial damage NTSB MKC87LA023Accident · No injuriesLimited investigationFinal reportCessna 150J · Colby, KSThe pilot stated that he departed his private airstrip, low on fuel, intending to refuel at the next stop where he was to conduct a business transaction. Unable to secure fuel there, and showing one quarter of a tank on each fuel gauge, he departed for Colby…Nov 25, 1986 · N60046 · Substantial damage NTSB MKC82DA145Accident · No injuriesFinal reportCessna 150J · Conway Springs, KSThe aircraft engine lost power during landing and the aircraft hit trees 100 yards short of the runway. Post-accident examination disclosed low compression on 3 cylinders and none on number four cylinder. The engine had been low on RPM since the beginning of…Aug 12, 1982 · N61142 · Destroyed NTSB MKC82DA048Accident · No injuriesFinal reportCessna 150 · Sabetha, KSThe pilot initiated a landing approach to runway 1 with the wind from 280 degrees at 18, gusting 25 knots. He entered final approach in a crab and was lined up with the runway. When over the threshold, the plane started to drift right. It settled to the…Mar 20, 1982 · N60761 · Substantial damage NTSB MKC80DCG39Accident · No injuriesClosedCessna 150J · Horton, KSAug 10, 1980 · N61024 · Substantial damage NTSB MKC80FA018Accident · 1 fatalClosedCessna 150 · Newton, KSJan 19, 1980 · N51274 · Destroyed NTSB MKC79DCG44Accident · No injuriesClosedCessna 150 · Ft Leavenworth, KSMay 23, 1979 · N5545G · Substantial damage NTSB MKC77DCG12Accident · No injuriesClosedCessna 150 · Lyndon, KSJan 30, 1977 · N51206 · Substantial damage NTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSJan 25, 1974 · N60544 · Destroyed NTSB MKC74AK008Accident · 1 fatalClosedCessna 150J · Emporia, KSAug 28, 1973 · N60410 · Substantial damage NTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damage NTSB MKC73DCQ21Accident · Minor injuriesClosedCessna 150J · Derby, KSOct 29, 1972 · N61140 · Substantial damage NTSB MKC73AK009Accident · 1 fatalClosedCessna 150J · Caldwell, KSJul 15, 1972 · N61025 · Destroyed NTSB MKC71DCQ03Accident · No injuriesClosedCessna 150 · Dodge City, KSJul 14, 1970 · N60246 · Substantial damage NTSB MKC69D0367Accident · No injuriesClosedCessna 150J · Johnson, KSMar 31, 1969 · N51024 · Substantial damage