NTSB investigations, IN
16 cases where NTSB found Incorrect action performance.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 3 |
| 2015 | 2 |
| 2017 | 3 |
| 2019 | 1 |
| 2024 | 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\" = 'IN' 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\", '02041015'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02041015')) 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 CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…NTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…NTSB CEN17LA302Accident · Minor injuriesLimited investigationFinal reportJames F Hake MTO Sport · Mentone, INThe pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.NTSB CEN17LA267Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ireland, INThe pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.NTSB CEN17FA127Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Chalmers, INThe pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.NTSB CEN15CA410Accident · No injuriesData collectionFinal reportPiper PA-17 · Delphi, INThe pilot's attempt to start the engine by himself without properly securing the airplane.NTSB CEN15CA293Accident · Serious injuriesData collectionFinal reportCessna A188B · Crawfordsville, INThe pilot's failure to maintain clearance from the powerline during an aerial application operations.NTSB CEN13CA515Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1B · Valparaiso, INThe pilot's improper recovery from a bounced landing.NTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.NTSB CEN13LA424Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Huntingburg, INThe pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.NTSB CEN12CA663Accident · Serious injuriesData collectionFinal reportJabiru USA Sport J170-SP · Goshen, INThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion.NTSB CEN12CA355Accident · Minor injuriesData collectionFinal reportRyan Navion · Rockville, INThe pilot’s failure to attain the proper touchdown point during landing, which resulted in a runway overrun.NTSB CEN11CA495Accident · No injuriesData collectionFinal reportCessna A188B · Greenstown, INThe pilot's failure to maintain adequate clearance from vegetation that caused increased drag during a low-level maneuvering flight.NTSB CEN09CA511Accident · No injuriesData collectionFinal reportBrantly B-2B · Martinsville, INThe pilot's improper recovery during the autorotation. Contributing to the accident was the pilot's delayed remedial action to abort the practice autorotation.NTSB CEN09CA435Accident · No injuriesData collectionFinal reportFlight Design Ctsw · North Vernon, INThe pilot's improper landing flare which resulted in a stall and nose over during touchdown.NTSB CEN09CA041Accident · No injuriesData collectionFinal reportCessna 172 · Monticello, INThe pilot stalled the airplane during a go-around. Contributing to the accident included the pilot's improper in-flight decision, the tailwind landing, and the pilot's failure to put the carburetor Heat to "OFF" during the go-around.