NTSB investigations: Cessna 150K, KY

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

NTSB investigations: Cessna 150K, KY per year, 1969–2026: 9 cases
1969	1
1971	2
1972	1
1974	1
1978	1
1983	1
1989	1
2006	1

Where

Open the map

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 ('2071822')) 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 ('2071822'))
  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 ('2071822'))
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 NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.Sep 2, 2006 · N6401G · Destroyed NTSB ATL90LA014Accident · No injuriesLimited investigationFinal reportCessna 150K · Vine Grove, KYInadequate preflight planning/preparation by the student pilot, which led to fuel exhaustion due to an inadequate supply of fuel. The pilot's failure to attain the proper touchdown point during the landing and the parked airplane were contributing factors.Oct 25, 1989 · N2662Q · Substantial damage NTSB ATL84LA060Accident · No injuriesLimited investigationFinal reportCessna 150K · Georgetown, KYEarlier in the day, an annual inspection had been completed. There were no refueling facilities on the arpt, so the plt/mechanic drove to another location & purchased a can of gasoline (6 gals) which he added to the tanks. He then started the eng &…Dec 1, 1983 · N6185G · Substantial damage NTSB IAD78FLQ22Accident · Serious injuriesClosedCessna 150K · Russell Spgs, KYJun 30, 1978 · N5905G · Substantial damage NTSB IAD74FL027Accident · No injuriesClosedCessna 150 · Frankfort, KYFeb 18, 1974 · N6045G · Substantial damage NTSB CHI72FLQ37Accident · No injuriesClosedCessna 150K · Lexington, KYMay 7, 1972 · N6467G · Substantial damage NTSB CHI71FLQ25Accident · No injuriesClosedCessna 150K · New Haven, KYJun 12, 1971 · N6045G · Substantial damage NTSB MIA71DLT15Accident · No injuriesClosedCessna 150 · Whitesville, KYMay 9, 1971 · N6245G · Substantial damage NTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYSep 15, 1969 · N5747G · Substantial damage