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 UNK64X1115Accident · No injuriesClosedCessna 150 · Ft Scott, KSMar 31, 1964 · N7938Z · Substantial damage NTSB UNK64X1110Accident · No injuriesClosedCessna 182E · Hutchinson, KSMar 30, 1964 · N9282X · Substantial damage NTSB UNK64X1099Accident · Minor injuriesClosedMooney M21 · Ottawa, KSMar 29, 1964 · N6719U · Substantial damage NTSB UNK64X1088Accident · No injuriesClosedCessna 172D · Wellington, KSMar 29, 1964 · N3835S · Substantial damage NTSB UNK64X1080Accident · No injuriesClosedMooney M21 · Kansas City, KSMar 28, 1964 · N8370E · Substantial damage NTSB UNK64X1054Accident · No injuriesClosedLear Jet 23 · Wichita, KSMar 27, 1964 · N802L · Substantial damage NTSB UNK64X1043Accident · No injuriesClosedPiper PA24 · Iola, KSMar 26, 1964 · N5449P · Substantial damage NTSB UNK64X1011Accident · No injuriesClosedCessna 172 · Lawrence, KSMar 21, 1964 · N3788S · Substantial damage NTSB UNK64X0937Accident · No injuriesClosedCessna 120 · Lane, KSMar 15, 1964 · N1795N · Substantial damage NTSB UNK64X0925Accident · No injuriesClosedCessna 150C · Bonner Spgs, KSMar 15, 1964 · N7952Z · Substantial damage NTSB UNK64X0905Accident · Serious injuriesClosedBeechcraft A45 · El Dorado, KSMar 14, 1964 · N7613B · Substantial damage NTSB UNK64X0904Accident · No injuriesClosedCessna 182D · Winfield, KSMar 13, 1964 · N8883X · Substantial damage NTSB UNK64X0896Accident · No injuriesClosedBeechcraft A35 · Topeka, KSMar 12, 1964 · N4554V · Substantial damage NTSB UNK64X0891Accident · No injuriesClosedMooney M21 · Kansas City, KSMar 12, 1964 · N6456U · Substantial damage NTSB UNK64X0862Accident · Minor injuriesClosedPiper PA24 · Clearwater, KSMar 9, 1964 · N7161P · Destroyed NTSB UNK64X0821Accident · No injuriesClosedPiper PA23 · Kansas City, KSMar 6, 1964 · N4051P · Substantial damage NTSB UNK64X0751Accident · No injuriesClosedPiper PA22 · Nortonville, KSFeb 29, 1964 · N5000Z · Substantial damage NTSB UNK64X0742Accident · No injuriesClosedBeechcraft 35 · Liberal, KSFeb 29, 1964 · N3558N · Substantial damage NTSB UNK64X0663Accident · Minor injuriesClosedPiper J3C · Garland, KSFeb 22, 1964 · N3557N · Destroyed NTSB UNK64X0640Accident · 1 fatalClosedCessna 310C · Jetmore, KSFeb 21, 1964 · N6712T · Destroyed NTSB UNK64X0560Accident · No injuriesClosedPiper PA22 · Arkansas Cit, KSFeb 14, 1964 · N4565A · Substantial damage NTSB UNK64X0546Accident · No injuriesClosedCessna 140 · Topeka, KSFeb 12, 1964 · N1647V · Substantial damage NTSB UNK64X0438Accident · No injuriesClosedGlobe Swift GC1B · Olathe, KSFeb 2, 1964 · N78289 · Substantial damage NTSB UNK64X0365Accident · No injuriesClosedPiper PA24 · Leoti, KSJan 26, 1964 · N5894P · Substantial damage NTSB UNK64X0356Accident · No injuriesClosedSwift GC1B · Olathe, KSJan 25, 1964 · N3843K · Substantial damage NTSB UNK64X0294Accident · No injuriesClosedTaylorcraft BC12D · Ellis, KSJan 19, 1964 · N96975 · Substantial damage NTSB UNK64X0194Accident · 1 fatalClosedBeechcraft J35 · Hill City Kans, KSJan 9, 1964 · N634T · Destroyed NTSB UNK64X0179Accident · No injuriesClosedLuscombe 8F · Pierceville, KSJan 6, 1964 · N1837B · Substantial damage NTSB UNK64X0176Accident · No injuriesClosedPiper PA30 · Lacrosse, KSJan 6, 1964 · N7121Y · Substantial damage NTSB UNK64X0153Accident · No injuriesClosedPiper PA24 · Wichita, KSJan 4, 1964 · N7161P · Substantial damage NTSB UNK64X0152Accident · No injuriesClosedLuscombe 8A · Bonner Sprgs, KSJan 4, 1964 · N2073B · Substantial damage NTSB UNK64X0108Accident · No injuriesClosedBeechcraft 23 · Haddam, KSJan 1, 1964 · N2348Z · Substantial damage NTSB MKC64A0027Accident · Serious injuriesClosedBoeing 707 · Topeka, KSSep 21, 1963 · N742TW · No damage NTSB UNK63X0103Accident · Serious injuriesClosedLockheed 1049G · Manhattan, KSMay 28, 1963 · N189S · Destroyed