NTSB investigations, IN
26 cases where NTSB found Performance/control parameters, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 3 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062000'))
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", '01062000')) 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 CEN24FA170Accident · 2 fatalClass 3 · FieldFinal reportZenith CH601 · Bristol, INThe pilot’s loss of control during the descent for reasons that could not be determined, which resulted in a steep descent into terrain.NTSB CEN23LA381Accident · Serious injuriesClass 4 · LimitedFinal reportGeorge Stone KIT FOX Model 3 · Scottsburg, INThe student pilot’s failure to maintain airplane control after takeoff that resulted in an impact with terrain.NTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB CEN20LA304Accident · 1 fatalClass 3 · LimitedFinal reportBrantly B2B · Monrovia, INThe pilot’s loss of control after takeoff for reasons that could not be determined based on the available information.NTSB CEN20FA038Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Evansville, INThe pilot’s failure to maintain control of the airplane.NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.NTSB CEN17LA144Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Wayne, INThe pilot receiving instruction’s failure to maintain airplane control during a crosswind landing in high gusting winds, and the flight instructor’s failure to maintain a proper airspeed and angle of attack during the go-around, which resulted in an…NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB CEN15FA194Accident · 1 fatalField investigationFinal reportS C Aerostar S A YAK 52TW · Advance, INThe pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN15LA098Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Parker City, INThe pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.NTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.NTSB CEN13FA446Accident · 1 fatalField investigationFinal reportCampbell Earl S JR RV-6A · Knox, INThe incapacitation of the pilot due to a cardiovascular event that prevented him from maintaining control of the airplane during the landing approach.NTSB CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…NTSB CEN12LA053Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Noblesville, INThe hard landing the pilot performed with a quartering tailwind, leading to the helicopter's rollover. Contributing to the accident was the pilot’s reliance on a weather service that did not provide a primary weather product.NTSB CEN11FA267Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · South Bend, INThe pilot’s failure to maintain airplane control while on final approach with a gusting crosswind and the subsequent aerodynamic stall and spin during the attempted go-around.NTSB CEN11FA201Accident · 1 fatalField investigationFinal reportCessna 421C · Connersville, INThe pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.NTSB CEN10CA387Accident · No injuriesData collectionFinal reportCessna 140 · Franklin, INThe pilot's improper touchdown point and excessive braking, which resulted in a nose over.NTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…NTSB CEN10CA062Accident · No injuriesData collectionFinal reportCessna 172S · Mt. Comfort, INThe pilot's failure to maintain directional control of the airplane while touching down during the landing.NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.NTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.NTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.NTSB CHI08CA122Accident · No injuriesData collectionFinal reportEvektor Aerotechnik SportStar Plus · Greenwood, INThe student pilot's failure to maintain control of the airplane during engine run-up.