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 MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSJul 5, 1976 · N3221J · Substantial damage NTSB MKC76DCQ62Accident · No injuriesClosedPiper PA-25 · Winfield, KSJul 1, 1976 · N6077Z · Substantial damage NTSB MKC76FCQ61Accident · 1 fatalClosedPiper PA-18A · Sharon Springs, KSJun 24, 1976 · N9924D · Destroyed NTSB MKC76DCQ63Accident · No injuriesClosedBell 47G5 · Scott City, KSJun 14, 1976 · N4095G · Substantial damage NTSB MKC76DCQ58Accident · Minor injuriesClosedAero-Comdr 600S2R · Tribune, KSJun 11, 1976 · N4976X · Substantial damage NTSB MKC76DCQ59Accident · Serious injuriesClosedAir Tractor AT-301 · Subletta, KSJun 10, 1976 · N4349S · Substantial damage NTSB MKC76AK060Accident · Serious injuriesClosedDehavilland DHC-2 · Carbondale, KSJun 10, 1976 · N90785 · Destroyed NTSB MKC76FCQ56Accident · 1 fatalClosedPiper PA-25 · Dighton, KSJun 9, 1976 · N7727Z · Substantial damage NTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSJun 9, 1976 · N16025 · Substantial damage NTSB MKC76DCQ57Accident · No injuriesClosedBell 47D-1 · Sublette, KSJun 4, 1976 · N908B · Substantial damage NTSB MKC76DCG77Accident · No injuriesClosedCessna 177RG · Gardner, KSJun 3, 1976 · N7972V · Substantial damage NTSB MKC76AK058Accident · No injuriesClosedLockheed L-1011 · Salina, KSJun 1, 1976 · N31013 · Substantial damage NTSB MKC76FCQ54Accident · No injuriesClosedCessna A150M · Wichita, KSMay 28, 1976 · N9842J · Substantial damage NTSB MKC76FCQ53Accident · No injuriesClosedMooney M20E · Iola, KSMay 27, 1976 · N5837Q · Substantial damage NTSB MKC76FCQ52Accident · Serious injuriesClosedCessna A188B · Plains, KSMay 27, 1976 · N53121 · Substantial damage NTSB MKC76DCQ51Accident · No injuriesClosedHughes 369 · Elkhart, KSMay 18, 1976 · N9153F · Substantial damage NTSB MKC76DCQ50Accident · No injuriesClosedCessna 210 · Ford, KSMay 4, 1976 · N8142G · Substantial damage NTSB MKC76AK056Accident · No injuriesClosedDassault DA-20 · Wichita, KSApr 28, 1976 · N21FE · Substantial damage NTSB MKC76OCQ48Accident · No injuriesClosedPiper PA-25 · Norton, KSApr 23, 1976 · N4976Y · Substantial damage NTSB MKC76DCQ49Accident · No injuriesClosedPiper PA-28 · Oberlin, KSApr 22, 1976 · N8055C · Substantial damage NTSB MKC76DCG70Accident · Minor injuriesClosedCallair A-9 · Atchison, KSApr 22, 1976 · N65042 · Substantial damage NTSB MKC76DCG46Accident · No injuriesClosedBeagle B121-2 · Wichita, KSApr 22, 1976 · N121BP · Substantial damage NTSB MKC76DCQ47Accident · No injuriesClosedCessna 182 · Wichita, KSApr 19, 1976 · N2061X · Substantial damage NTSB MKC76DCQ45Accident · No injuriesClosedCessna 172F · Belmont, KSApr 18, 1976 · N8646U · Substantial damage NTSB MKC76FCQ44Accident · No injuriesClosedBeech C35 · Mankato, KSApr 17, 1976 · N2004D · Substantial damage NTSB MKC76FCQ43Accident · No injuriesClosedCessna 172 · Meade, KSApr 16, 1976 · N13013 · Substantial damage NTSB MKC76FCG69Accident · No injuriesClosedMooney M20G · Ottawa, KSApr 11, 1976 · N6918N · Substantial damage NTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSApr 3, 1976 · N3658J · Substantial damage NTSB MKC76DCQ42Accident · No injuriesClosedCessna 172 · Dodge City, KSMar 26, 1976 · N9407H · Substantial damage NTSB MKC76AK050Accident · 1 fatalClosedMaule M-4 · Pittsburg, KSMar 26, 1976 · N40624 · Destroyed NTSB MKC76AK049Accident · Minor injuriesClosedCessna 207 · Lansing, KSMar 23, 1976 · N1674U · Substantial damage NTSB MKC76DCG61Accident · No injuriesClosedPiper PA-30 · Ft Leavenworth, KSMar 21, 1976 · N8550Y · Substantial damage NTSB MKC76FCG58Accident · Minor injuriesClosedPiper PA-28 · Leawood, KSMar 18, 1976 · N500FL · Substantial damage NTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSMar 16, 1976 · N6095J · Substantial damage NTSB MKC76AK048Accident · 2 fatalClosedGrum Amer AA1-B · Medicine Lodge, KSMar 15, 1976 · N1462R · Destroyed NTSB MKC76DCQ41Accident · No injuriesClosedBeech 35-33 · Benton, KSMar 13, 1976 · N856R · Substantial damage NTSB MKC76DCQ40Accident · No injuriesClosedBrantley B-2 · Dodge City, KSMar 13, 1976 · N5903X · Substantial damage NTSB MKC76FCQ39Accident · Serious injuriesClosedPiper PA-22 · Madison, KSMar 6, 1976 · N3827P · Substantial damage NTSB MKC76FCG55Accident · Minor injuriesClosedCessna 205A · Kansas City, KSMar 6, 1976 · N4806U · Substantial damage NTSB MKC76FCQ38Accident · Serious injuriesClosedBede BD-5J · Newton, KSMar 5, 1976 · N99775 · Destroyed NTSB MKC76DCQ36Accident · Minor injuriesClosedInterstate S-1A · Spivey, KSFeb 28, 1976 · N37377 · Substantial damage NTSB MKC76DCQ35Accident · No injuriesClosedPiper PA-22 · Beaumont, KSFeb 28, 1976 · N2328P · Substantial damage NTSB MKC76DCQ34Accident · No injuriesClosedCessna U206 · Beaumont, KSFeb 24, 1976 · N4457Q · Substantial damage NTSB MKC76DCG51Accident · No injuriesClosedCessna 210A · Olathe, KSFeb 21, 1976 · N6674X · Substantial damage NTSB MKC76DCQ33Accident · No injuriesClosedCessna 172 · Maize, KSFeb 19, 1976 · N1415Y · Substantial damage NTSB MKC76DCQ37Accident · Minor injuriesClosedPiper PA-34 · Medicine Lodge, KSFeb 17, 1976 · N41513 · Substantial damage NTSB MKC76FCQ32Accident · No injuriesClosedBell 47G · Charleston, KSFeb 15, 1976 · N967B · Destroyed NTSB MKC76FCQ30Accident · 1 fatalClosedBede BD-5JX · Newton, KSFeb 11, 1976 · N13SL · Substantial damage NTSB MKC76DCG50Accident · No injuriesClosedCessna 172 · Topeka, KSFeb 11, 1976 · N5232T · Substantial damage NTSB MKC76DCQ31Accident · No injuriesClosedPiper PA-28 · Russell, KSFeb 9, 1976 · N3664K · Substantial damage