NTSB investigations, WI
4 cases where NTSB found Planning/preparation, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02061000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02061000')) 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 CEN15LA345Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Nekoosa, WIThe pilot’s inadequate preflight planning, which resulted in his attempt to take off for the agricultural application flight with the airplane over its maximum gross weight in high-density altitude conditions and led to the airplane’s degraded climb…NTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.NTSB CEN12CA469Accident · Serious injuriesData collectionFinal reportPurtee Kevin M Pietenpol Aircamper · Broadhead, WIThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power during takeoff, and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted…NTSB CHI08CA287Accident · Minor injuriesData collectionFinal reportCessna 172M · Three Lakes, WIThe pilot's failure to attain sufficient altitude to avoid the trees during initial climb. Contributing to the accident were the pilot's failure to ensure the security of the entrance door before takeoff and the unintentional opening of the door.