NTSB investigations, IN
9 cases where the first occurrence was “Dragged wing,rotor,pod,float or tail/skid”.
Cases per year
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 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\" = 'IN' 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\" = 160)
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" = 'IN' 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" = 160) 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 CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB CHI02LA008Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Jeffersonville, INThe dual student pilot's failure to maintain control of the helicopter, his failure to maintain altitude/clearance from the terrain, and the inadequate supervision by the flight instructor. A factor was the gusty wind condition.NTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.NTSB CHI98LA206Accident · Minor injuriesLimited investigationFinal reportParker Rotorway 162-F · Manchester, INthe pilot misjudged the flare.NTSB CHI98LA152Accident · No injuriesLimited investigationFinal reportRead Rotorway Executive · Valparaiso, INthe pilot not maintaining adequate clearance with the ground during hover. Factors which contributed to this accident were the pilot's execution of a hovering turn at too low of an altitude, inadequate preflight preparation, and failing to remove the…NTSB CHI98LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, INthe pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.NTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.NTSB CHI86FET02Accident · 1 fatalFinal reportPiper PA-28-180 · Syracuse, INThe acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…NTSB CHI83LA098Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Warsaw, INThe plt reported that during arrival, he contacted UNICOM for an advisory. Reportedly, the wind at that time was from 090 deg at 15 KTS, within the x-wind capability of the acft. During the approach and landing, the plt slipped the plane to a normal…