NTSB investigations, WI
6 cases where the sequence of events included Aircraft structural failure.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2018 | 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\" = 'WI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '337' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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" = 'WI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '337' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA18CA329Accident · No injuriesData collectionFinal reportDobbs George Coot · Malone, WIThe pilot’s improper decision to take off with a known structural issue, which resulted in hull damage.NTSB CEN17FA231Accident · Serious injuriesField investigationFinal reportGefa-Flug AS-105-GD · Hartford, WIThe overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.NTSB CEN14IA085Incident · No injuriesIncident investigationFinal reportBeech E90 · Eau Claire, WIThe failure of the copilot’s windshield inner layer due to a peel chip that developed as a result of mechanical and thermal expansion stresses.NTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.NTSB CEN11LA050Accident · 1 fatalLimited investigationFinal reportMcfarland Bill Challenger II · Praire Du Sac, WIThe separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.NTSB CEN09FA340Accident · 2 fatalField investigationFinal reportGulfstream American AA-5B · Humbird, WIThe pilot's decision to attempt a visual flight rules flight into an area of known instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.