Skip to content

NTSB investigations, KS

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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' 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'
  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'
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 MKC79FCG75Accident · Minor injuriesClosedCessna 340A · Topeka, KSAug 24, 1979 · N800BC · Substantial damage NTSB MKC79DCQ43Accident · No injuriesClosedCessna 172N · Wichita, KSAug 21, 1979 · N738AT · Substantial damage NTSB MKC79FCG71Accident · No injuriesClosedBeech A23-24 · Reading, KSAug 11, 1979 · N4744J · Substantial damage NTSB MKC79DCQ42Accident · No injuriesClosedCessna 152 · Clements, KSAug 11, 1979 · N89876 · Substantial damage NTSB MKC79FCG70Accident · No injuriesClosedCessna 150L · Bonner Springs, KSAug 9, 1979 · N19030 · Substantial damage NTSB MKC79FCQ41Accident · No injuriesClosedGrumman AA5B · Hoxie, KSAug 6, 1979 · N28756 · Substantial damage NTSB MKC79FCG67Accident · Minor injuriesClosedBeech 35 · Stilwell, KSAug 6, 1979 · N4513V · Substantial damage NTSB MKC79FA046Accident · 7 fatalClosedMitsubishi MU-2B · Hays, KSAug 3, 1979 · N208MA · Destroyed NTSB MKC79FCQ38Accident · No injuriesClosedCessna 150H · Columbus, KSJul 28, 1979 · N5131G · Substantial damage NTSB MKC79FCQ39Accident · No injuriesClosedDyke Delta JD-2 · Tribune, KSJul 27, 1979 · N18DW · Substantial damage NTSB MKC79DCQ40Accident · No injuriesClosedCessna 172 · Sharon Springs, KSJul 27, 1979 · N7129T · Substantial damage NTSB MKC79FCQ37Accident · No injuriesClosedPiper PA-28 · Halstead, KSJul 26, 1979 · N6462C · Substantial damage NTSB MKC79DCG62Accident · No injuriesClosedBoeing A75 · Effingham, KSJul 21, 1979 · N75360 · Substantial damage NTSB MKC79FCG60Accident · No injuriesClosedPitts S2A · Ottawa, KSJul 20, 1979 · N60LG · Substantial damage NTSB MKC79DCG56Accident · No injuriesClosedPiper PA-28 · Leawood, KSJul 4, 1979 · N3935K · Substantial damage NTSB MKC79DCG54Accident · No injuriesClosedPitts S2 · Garnett, KSJul 4, 1979 · N4TW · Substantial damage NTSB MKC79FCQ35Accident · No injuriesClosedPiper PA-18A · Westfall, KSJul 1, 1979 · N8098D · Substantial damage NTSB MKC79FCQ34Accident · Minor injuriesClosedInterceptor Super · Johnson, KSJun 29, 1979 · N10347 · Substantial damage NTSB MKC79FCG52Accident · No injuriesClosedGrumman AA1B · Garnett, KSJun 29, 1979 · N8861L · Destroyed NTSB MKC79DCQ36Accident · Serious injuriesClosedCessna 152 · Arkansas City, KSJun 27, 1979 · N89142 · Destroyed NTSB MKC79FCG51Accident · No injuriesClosedMooney M20A · Hillsdale, KSJun 26, 1979 · N6072X · Substantial damage NTSB MKC79FCQ33Accident · No injuriesClosedRockwell S2R · Hoxie, KSJun 24, 1979 · N5008X · Substantial damage NTSB MKC79DCQ32Accident · Minor injuriesClosedPiper PA-18 · Great Bend, KSJun 23, 1979 · N74990 · Substantial damage NTSB LAX791A068Incident · No injuriesClosedLockheed L-1011 · Hutchinson, KSJun 21, 1979 · N11001 · Minor damage NTSB MKC79DCQ31Accident · No injuriesClosedPiper PA-28 · Wellington, KSJun 17, 1979 · N7633F · Substantial damage NTSB MKC79DCQ30Accident · No injuriesClosedGrumman G-164A · Moscow, KSJun 17, 1979 · N8842H · Destroyed NTSB MKC79FCQ29Accident · Serious injuriesClosedPiper PA-25 · Atwood, KSJun 14, 1979 · N6045Z · Substantial damage NTSB MKC79DCQ28Accident · No injuriesClosedCessna 340 · Manhattan, KSJun 6, 1979 · N512SK · Substantial damage NTSB MKC79DCG49Accident · No injuriesClosedBeech P35 · Olathe, KSJun 6, 1979 · N8648M · Substantial damage NTSB MKC79FCQ27Accident · 1 fatalClosedStitts JD1 · Wichita, KSJun 5, 1979 · N3JD · Destroyed NTSB MKC79DCQ26Accident · Minor injuriesClosedPiper PA-28 · Hope, KSJun 5, 1979 · N7006C · Substantial damage NTSB MKC79FCQ25Accident · 1 fatalClosedCallair A-9B · Yates Center, KSJun 2, 1979 · N7766V · Substantial damage NTSB MKC79DCG50Accident · Minor injuriesClosedPiper J3C-65 · Richmond, KSJun 2, 1979 · N24905 · Substantial damage NTSB MKC79FCQ24Accident · No injuriesClosedGlobe GC1B · Goodland, KSMay 31, 1979 · N80883 · Substantial damage NTSB MKC79DCG44Accident · No injuriesClosedCessna 150 · Ft Leavenworth, KSMay 23, 1979 · N5545G · Substantial damage NTSB MKC79FCQ23Accident · Serious injuriesClosedPiper PA-20 · Radium, KSMay 19, 1979 · N7798K · Destroyed NTSB MKC79DCG43Accident · No injuriesClosedCessna 172 · Lawrence, KSMay 16, 1979 · N566Q · Substantial damage NTSB MKC79DCQ22Accident · No injuriesClosedCessna 150 · Derby, KSMay 14, 1979 · N11445 · Substantial damage NTSB MKC79FCQ21Accident · No injuriesClosedCessna A188B · Minneapolis, KSMay 7, 1979 · N21622 · Substantial damage NTSB MKC79FCQ20Accident · 1 fatalClosedPiper PA-25 · Mayday, KSApr 28, 1979 · N7641Z · Destroyed NTSB MKC79FCQ19Accident · No injuriesClosedBeech 95-B55 · Wellington, KSApr 21, 1979 · N121LG · Substantial damage NTSB MKC79DCQ18Accident · Minor injuriesClosedCessna 172 · Belleville, KSApr 18, 1979 · N1455U · Substantial damage NTSB MKC79FCG38Accident · No injuriesClosedMitsubishi MU-2B · Gardner, KSApr 9, 1979 · N251M · Substantial damage NTSB MKC79DCG37Accident · No injuriesClosedCessna 152 · Olathe, KSApr 9, 1979 · N67845 · Substantial damage NTSB MKC79DCQ17Accident · No injuriesClosedCessna 150 · Benton, KSMar 24, 1979 · N45284 · Substantial damage NTSB MKC79FA023Accident · Serious injuriesClosedCessna 172 · Liberal, KSMar 22, 1979 · N2029E · 2 aircraft · Destroyed NTSB MKC79FA022Accident · 2 fatalClosedChampion 7GCB · Waverly, KSMar 16, 1979 · N9835Y · Destroyed NTSB MKC79FCQ16Accident · No injuriesClosedCessna T210 · Coffeyville, KSFeb 28, 1979 · N6514B · Destroyed NTSB MKC79FCG31Accident · No injuriesClosedCessna 150 · Olathe, KSFeb 26, 1979 · N6063T · Substantial damage NTSB MKC79FA019Accident · 1 fatalClosedCessna 172M · Fort Scott, KSFeb 26, 1979 · N1539V · Substantial damage