NTSB investigations, IA
7 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2005 | 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\" = 'IA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 430)
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" = 'IA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430) 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 CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…NTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).NTSB CHI96LA102Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Brighton, IAThe pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.NTSB MKC89LA031Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Martelle, IAAnticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…NTSB MKC85FA217Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · What Cheer, IAThe acft was observed flying through the top of a tree, then through a four strand high voltage pwr line. Final impact was relatively flat in a soy-bean field. The plt later stated that he had become disoriented in flt and hallucinated that he was in a Piper…NTSB MKC85LA029Accident · 1 fatalLimited investigationFinal reportSikorsky S58J · Storm Lake, IAA passenger was being transported from a boat to shore. The plt lowered a wheel strut to the boat for the boarding and says he received a radio call from the passenger saying, 'ok I'm ready let's go.' The plt assumed that he was inside the acft and a climb…NTSB MKC82DA102Accident · No injuriesFinal reportBalloon Works Firefly 6 · Hudson, IAThe Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000…