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 MKC81DCQ21Accident · No injuriesClosedCessna 182 · Benton, KSApr 5, 1981 · N7394S · Substantial damage NTSB MKC81DCQ20Accident · No injuriesClosedPiper PA-28R · Baxter Springs, KSApr 5, 1981 · N3857T · Substantial damage NTSB MKC81FCQ22Accident · Minor injuriesClosedPiper PA-25 · Norton, KSApr 2, 1981 · N8586L · Substantial damage NTSB MKC81DCQ19Accident · No injuriesClosedPiper PA-28 · Hugoton, KSMar 29, 1981 · N9097W · Substantial damage NTSB MKC81FCQ18Accident · Minor injuriesClosedCessna 150K · Haysville, KSMar 26, 1981 · N6418G · Substantial damage NTSB MKC81DCG25Accident · No injuriesClosedCessna 172H · St Marys, KSMar 23, 1981 · N8239L · Substantial damage NTSB MKC81FCQ17Accident · Minor injuriesClosedBeech A36 · Hill City, KSMar 19, 1981 · N2022A · Substantial damage NTSB MKC81FCQ16Accident · No injuriesClosedCessna 150 · Wichita, KSMar 11, 1981 · N704TL · Substantial damage NTSB MKC81DCQ15Accident · Minor injuriesClosedPiper PA-28R · Goodland, KSMar 3, 1981 · N2253M · Substantial damage NTSB MKC81DCQ14Accident · No injuriesClosedPiper PA-32R · Osborne, KSFeb 22, 1981 · N6168H · Substantial damage NTSB MKC81FCQ13Accident · Minor injuriesClosedPiper PA-28R · Agra, KSFeb 20, 1981 · N712HS · Substantial damage NTSB MKC81FCG22Accident · No injuriesClosedCessna 150M · Eudora, KSFeb 18, 1981 · N8270U · Substantial damage NTSB MKC81FA019Accident · 1 fatalClosedCessna 172 · Lawrence, KSFeb 13, 1981 · N1982V · Destroyed NTSB MKC81FCQ12Accident · No injuriesClosedCessna 401B · Goodland, KSFeb 9, 1981 · N7986Q · Substantial damage NTSB MKC81DCQ11Accident · No injuriesClosedCessna 188 · Plains, KSJan 28, 1981 · N731SM · Substantial damage NTSB MKC81DCQ10Accident · Serious injuriesClosedPiper PA-18 · Manhattan, KSJan 24, 1981 · N2334H · Destroyed NTSB MKC81FCQ09Accident · Minor injuriesClosedBeech C23 · Cheney, KSJan 17, 1981 · N18975 · Substantial damage NTSB MKC81FCQ08Accident · No injuriesClosedCessna T210 · Goddard, KSJan 12, 1981 · N5260Y · Substantial damage NTSB MKC81FCQ07Accident · Minor injuriesClosedScorpion 133 · Ulysses, KSDec 27, 1980 · N4990Y · Substantial damage NTSB MKC81FCQ06Accident · No injuriesClosedPiper PA-28 · Wellington, KSDec 18, 1980 · N6847J · Substantial damage NTSB MKC81FA010Accident · No injuriesClosedSwearingen SA226T · Kansas City, KSDec 10, 1980 · N11RM · Substantial damage NTSB MKC81FCQ04Accident · No injuriesClosedPiper PA-28 · Wichita, KSNov 20, 1980 · N8807J · Substantial damage NTSB MKC81FCG16Accident · No injuriesClosedBellanca 17-31 · Kansas City, KSNov 15, 1980 · N103CB · Substantial damage NTSB MKC81FCQ05Accident · Minor injuriesClosedVarieze 01 · Pittsburg, KSNov 11, 1980 · N62MV · Substantial damage NTSB MKC81DA011Accident · No injuriesClosedBarnes AX-7 · Topeka, KSNov 2, 1980 · N27045 · Substantial damage NTSB MKC81DCQ03Accident · No injuriesClosedCassutt 3M · Liberal, KSOct 25, 1980 · N533V · Substantial damage NTSB MKC81DCQ02Accident · No injuriesClosedCessna 182A · Cedar Vale, KSOct 18, 1980 · N991T · Substantial damage NTSB MKC81FCG03Accident · No injuriesClosedBeech 58 · Olathe, KSOct 5, 1980 · N555GP · Substantial damage NTSB MKC81DCQ01Accident · No injuriesClosedHelio Acft H-295 · Johnson, KSOct 4, 1980 · N6469V · Substantial damage NTSB MKC81DCG01Accident · No injuriesClosedStinson 108-1 · Olathe, KSOct 1, 1980 · N97072 · Substantial damage NTSB MKC80DCG48Accident · No injuriesClosedCessna 172 · Holton, KSSep 29, 1980 · N7424A · Substantial damage NTSB MKC80FA058Accident · 1 fatalClosedCessna 172M · Cassoday, KSSep 23, 1980 · N1841V · Destroyed NTSB MKC80DCQ34Accident · No injuriesClosedCessna 150 · Mcpherson, KSSep 20, 1980 · N3540L · Substantial damage NTSB MKC80FCG46Accident · No injuriesClosedCessna 150 · Desoto, KSSep 8, 1980 · N5452Q · Substantial damage NTSB MKC80FA053Accident · 2 fatalClosedTaylorcraft BC12-D · Sedan, KSSep 6, 1980 · N44149 · Destroyed NTSB MKC80DCG44Accident · No injuriesClosedBeech 95-B55 · Olathe, KSSep 5, 1980 · N4267S · Substantial damage NTSB MKC80DCQ33Accident · No injuriesClosedCessna 188 · Protection, KSSep 1, 1980 · N9429G · Substantial damage NTSB MKC80DCQ32Accident · No injuriesClosedCessna 172 · Wichita, KSSep 1, 1980 · N6592D · Substantial damage NTSB MKC80FA052Accident · No injuriesClosedGlobe GC-1B · Benton, KSAug 30, 1980 · N3859K · Substantial damage NTSB MKC80FCQ31Accident · No injuriesClosedCessna 177B · Dodge City, KSAug 21, 1980 · N32549 · Substantial damage NTSB MKC80FCG42Accident · No injuriesClosedCessna 182G · Ft Leavenworth, KSAug 21, 1980 · N2483R · Substantial damage NTSB MKC80DCQ30Accident · No injuriesClosedGrumman G-164B · Cimarron, KSAug 17, 1980 · N6611Q · Destroyed NTSB MKC80DCG39Accident · No injuriesClosedCessna 150J · Horton, KSAug 10, 1980 · N61024 · Substantial damage NTSB MKC80DCQ29Accident · No injuriesClosedCessna 172 · Hoxie, KSAug 8, 1980 · N736FX · Substantial damage NTSB MKC80DCQ28Accident · No injuriesClosedVarieze 01 · Dodge City, KSAug 7, 1980 · N124G · Substantial damage NTSB MKC80DCQ27Accident · No injuriesClosedCessna 140 · El Dorado, KSAug 3, 1980 · N76448 · Substantial damage NTSB MKC80DCQ26Accident · No injuriesClosedCessna 152 · Norwick, KSAug 3, 1980 · N5338M · Substantial damage NTSB MKC80FCQ25Accident · 1 fatalClosedPiper PA-25 · Garden City, KSJul 29, 1980 · N8759L · Destroyed NTSB MKC80FCG34Accident · No injuriesClosedBeech 58 · Kansas City, KSJul 18, 1980 · N4494A · Substantial damage NTSB MKC80DCG33Accident · No injuriesClosedRose A&M Parake · Ottawa, KSJul 17, 1980 · N14883 · Substantial damage