NTSB investigations, IL
23 cases where NTSB found Experience/knowledge.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 2 |
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\" = 'IL' 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\", '0203'))
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" = 'IL' 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", '0203')) 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 DCA22LA175Accident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Chicago, ILThe ground controller’s inappropriate routing of the B777 through a non-movement area, resulting in the airplane’s right wingtip contacting a light pole. Contributing to the accident was the lack of an appropriate display of taxiway BB2 as a restricted…NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB CEN20LA168Accident · 1 fatalClass 3 · LimitedFinal reportYakovlev YAK 52 · Palmyra, ILA loss of control during a low-altitude aerobatic maneuver.NTSB CEN18FA259Accident · Serious injuriesField investigationFinal reportEurocopter Deutschland EC135 P1 · Chicago, ILThe pilot's inadvertent disabling of the No. 1 and No. 2 engines' electronic engine control systems, which resulted in engine and rotor overspeed conditions, a subsequent autorotation, and a hard landing. Contributing to the accident were the pilot's…NTSB CEN18LA043Accident · No injuriesLimited investigationFinal reportRutten Phil J Pietenpol · De Kalb, ILThe pilot’s excessive rudder and brake applications during landing, which caused the airplane to nose over.NTSB CEN16LA263Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · Newark, ILThe student pilot's failure to maintain directional control on landing. Contributing to the accident was the pilot's lack of flight experience.NTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.NTSB CEN15FA347Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5A · Harrisburg, ILThe student pilot's improper decision to conduct a flight in dark, night conditions and his subsequent controlled flight into terrain.NTSB GAA15CA087Accident · No injuriesData collectionFinal reportSmith Vilas Kitfox · McLeansboro, ILThe pilot's failure to maintain attitude control during the landing roll. A contributing factor was the pilot's lack of training and experience in this airplane make and model.NTSB CEN15CA223Accident · No injuriesData collectionFinal reportPiper J3C-65 · De Kalb, ILThe pilot's loss of positional awareness while taxiing, resulting in a collision with a parked and unoccupied airplane. Contributing to the accident was the pilot's difficulty seeing over the nose of the airplane, his preoccupation with trying to control the…NTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB CEN13LA506Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Franklin, ILThe failure of both pilots, one of whom was noncertificated, to maintain adequate visual lookout while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the pilots’ inadequate communication about their intended…NTSB CEN12FA619Accident · 1 fatalField investigationFinal reportWiggins AIR Boss · Lansing, ILThe pilot's failure to obtain adequate familiarization with gyroplane operations before attempting a flight test of the recently completed gyroplane, which resulted in his failure to maintain control during the accident flight.NTSB CEN12FA073Accident · 1 fatalField investigationFinal reportSkykits Savannah VGW · Plato Center, ILThe noncertificated pilot’s decision to fly the airplane without receiving any flight instruction in the airplane, which resulted in his failure to maintain sufficient airspeed during takeoff and the subsequent aerodynamic stall.NTSB CEN12IA050Incident · No injuriesIncident investigationFinal reportNusbaum Vaquero · Hebron, ILThe pilot’s operation of the airplane with known medical conditions and his subsequent heart attack during the flight.NTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…NTSB CEN11LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-47UF · Chicago, ILThe Boeing 747 first officer’s failure to maintain clearance from another airplane while taxiing due to his inadequate judgment of the distance between the airplanes.NTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.NTSB CEN10CA232Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · Highland, ILThe pilot's inadequate preflight planning and his delayed aborted takeoff.NTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.NTSB CEN09LA265Accident · Serious injuriesLimited investigationFinal reportT Bird T Bird II · Carlock, ILThe pilot's failure to gain sufficient altitude during the takeoff in order to avoid contacting the cameraman. Contributing to the accident was the pilot's lack of experience.NTSB CEN09CA028Accident · No injuriesData collectionFinal reportHoward Super Sky Raider · Tuscola, ILThe pilot failed to maintain directional control during takeoff roll. A contributing factor was the cornfield and the pilot's lack of recent experience.NTSB OPS09IA001Incident · No injuriesIncident investigationFinal reportPeoria, ILThe tower local controller's failure to provide adequate separation between EGF4075 and SKW5961 that landed on intersecting runways.