NTSB investigations, KS
6 cases where NTSB found Aircraft structures.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 2 |
| 2017 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0103'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0103')) 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 ERA22FA320Accident · 1 fatalClass 3 · FieldFinal reportKnight AA Nieuport 28 · Basehor, KSThe pilot’s incorrect installation of the left-wing strut, which resulted in a loss of airplane control during takeoff and a subsequent aerodynamic stall and spin from which the pilot could not recover.NTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.NTSB CEN13LA514Accident · Minor injuriesLimited investigationFinal reportChallenger II · Emporia, KSThe right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.NTSB CEN13LA265Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lyons, KSThe pilot's diverted attention after the door hinge failed and a piece of door glass struck the pilot, resulting in the airplane's descent into the crops and impact with terrain.NTSB CEN11CA679Accident · No injuriesData collectionFinal reportWaltman Theodore J Moose · Hays, KSRudder flutter due to the design changes to the airplane's horizontal stabilizer.NTSB CEN09CA552Accident · No injuriesData collectionFinal reportCessna 150F · Abilene, KSThe pilot's inadequate crosswind landing technique, resulting in an excessive side load on the left landing gear that led to an overload failure of its axle.