NTSB investigations, 2016
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 year(c.\"eventDate\") = 2016 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 year(c."eventDate") = 2016 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 ANC16CA041Accident · No injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a collision with trees and a ground-loop.NTSB WPR16LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Schafer Meadows, MTA loss of directional control while landing, which resulted in a runway excursion and landing gear collapse for reasons that could not be determined.NTSB GAA16CA375Accident · No injuriesData collectionFinal reportCessna A185 · Hayden Lake, IDThe pilot's failure to retract the amphibious airplane's land-wheels prior to landing on a lake, which resulted in a nose over.NTSB GAA16CA349Accident · No injuriesData collectionFinal reportCessna 150 · Reno, NVThe student pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, impact with a sign, and left wing damage.NTSB GAA16CA346Accident · No injuriesData collectionFinal reportCessna 172 · Flushing, MIThe collision with a deer during touchdown of a night landing, which resulted in substantial damage to the horizontal stabilizer and elevator of the airplane.NTSB GAA16CA335Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S 6S · Richwood, OHThe pilot's exceedance of the critical angle of attack during an initial climb of an aborted landing, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB ERA16WA240Accident · 5 fatalForeign investigationBell Helicopter 407 · Jundiaí, BrazilOn June 26, 2016, about 1110 coordinated universal time, a Bell 407, Brazilian registration PR-CBB, was destroyed during a collision with terrain and post-crash fire in Jundiaí, Brazil. The pilot and four passengers were fatally injured.The flight had…NTSB ERA16LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Hollywood, FLA partial loss of engine power during the initial climb for undetermined reasons.NTSB DCA16WA191Incident · No injuriesForeign investigationAirbus Industrie A330 323 · London, United KingdomAir Accident Investigation Branch (AAIB) notified the NTSB of a serious incident involving a AIRBUS INDUSTRIE A330 323 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of United…NTSB DCA16RA190Accident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Air Accident Investigations Bureau (AAIB) of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under…NTSB DCA16CA193Accident · Serious injuriesData collectionFinal reportBoeing 737 · New Orleans, LAthe improper placement of the coffee pot on the beverage cart and failure to use a safe-pour lid.NTSB CEN16RA233Accident · No injuriesForeign investigationBell 407 · Kassel, Hesse, Germany, GermanyOn June 26, 2016, about 1420 hours universal coordinated time, a Bell model 407 helicopter, German registration D-HEAB, sustained substantial damage during a hard landing following a loss of engine power near Kassel, Hesse, Germany. The pilot was not injured.…NTSB CEN16LA247Accident · Serious injuriesLimited investigationFinal reportBeech E 90 · Longmont, COThe pilot's unintentional activation of the green jump light before the airplane was properly configured and slowed for a jump and the jumpers' improper decision to continue with the jump after they recognized that the airplane was at a higher-than-normal…NTSB CEN16LA235Accident · No injuriesLimited investigationFinal reportCessna 182 · Kankakee, ILAa total loss of engine power due to fuel starvation, which resulted from the low level of fuel unporting during a rapid spiraling descent.NTSB ANC16LA035Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108 · Big Lake, AKA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB WPR16CA147Accident · No injuriesData collectionFinal reportStinson L 5G · Beckwourth, CAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the check pilot's failure to act in a timely manner to prevent the airplane from departing the runway.NTSB GAA16CA344Accident · No injuriesData collectionFinal reportBenjamin Harold E RV-4 · Fitchburg, MAThe pilot's failure to maintain directional control upon landing, which resulted in a runway excursion followed by impact with terrain.NTSB GAA16CA338Accident · No injuriesData collectionFinal reportNorth American SNJ · Jackson, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, right main landing gear collapse, and impact with the ground.NTSB GAA16CA336Accident · No injuriesData collectionFinal reportCessna 152 · Delta, COThe pilot exceeded the critical angle of attack during the initial climb in tailwind conditions, which resulted in an aerodynamic stall.NTSB GAA16CA334Accident · No injuriesData collectionFinal reportHubbard William H Lightning · Kokomo, INThe pilot's failure to maintain directional control during the landing flare at night, which resulted in an impact with a runway light and runway sign.NTSB GAA16CA333Accident · Minor injuriesData collectionFinal reportCessna 172 · Anthony, NMThe pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water.NTSB ERA16WA245Accident · 2 fatalForeign investigationLake LA4 · Región de Los Lagos, ChileOn June 25, 2016, about 2045 coordinated universal time (1645 local time), a Lake L-4-200, amphibious airplane, Chilean registration CC-POK, was substantially damaged when it collided with a powerline during a local flight over the Región de Los Lagos, Chile.…NTSB ERA16WA232Accident · No injuriesForeign investigationCessna U206 · Fresh Creek, BahamasOn June 25, 2016, about 2106 Universal Coordinated Time (UTC), a Cessna U206F, N9662G, operated by Chrimat Inc., was substantially damaged following a loss of engine power and forced landing at Fresh Creek, Bahamas. The pilot was not injured. The airplane…NTSB ERA16LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Hollywood, FLThe pilot’s inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.NTSB GAA16CA350Accident · No injuriesData collectionFinal reportPiper PA 24 · Springfield, MOThe pilot's failure to ensure that the landing gear was in the down and locked position prior to touchdown.NTSB ERA16LA234Accident · No injuriesLimited investigationFinal reportPiper PA28 · Poughkeepsie, NYAn overstress failure of the left main landing gear attachment bolts, which resulted in the left main landing gear collapse.NTSB CEN16LA234Accident · No injuriesLimited investigationFinal reportNorth American Navion · Alamogordo, NMThe failure of the No. 5 exhaust valve key spring, which resulted in a total loss of engine power.NTSB WPR16FA130Accident · 2 fatalField investigationFinal reportRobinson Helicopter R66 · Wikieup, AZAn encounter with turbulence due to updrafts and/or dust devils that resulted in mast bumping and an in-flight break-up.NTSB GAA16CA332Accident · No injuriesData collectionFinal reportThrush S2R · Lazbuddie, TXThe pilot's failure to avoid the metering loop pole during an aerial application.NTSB ERA16LA228Accident · Serious injuriesLimited investigationFinal reportAmerican AA1 · Knoxville, TNThe pilot's failure to maintain directional control during the landing roll in a quartering headwind.NTSB ERA16CA229Accident · No injuriesData collectionFinal reportCessna 182T · Crystal River, FLThe pilot's failure to execute a go-around following an unstabilized approach, which resulted in a bounced landing and runway excursion.NTSB CEN16WA262Accident · 2 fatalForeign investigationLiberty XL · La Lima, HondurasOn June 23, 2016, about 2259 UTC, a Discovery Aviation, Incorporated, Liberty XL-2, Honduran registration HR-HZT, owned and operated by Horizontes Flight School was destroyed when it impacted the roof of a house in a residential neighborhood near La Lima,…NTSB CEN16WA232Incident · No injuriesForeign investigationBeech 65A90 · Hannover, GermanyThe Bundesstelle für Flugunfalluntersuchung (BFU) of Germany has notified the NTSB of an incident involving a Beech 65-A90-1 airplane, OO-SAD, that occurred on June 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU…NTSB WPR16LA129Accident · No injuriesClass 3 · LimitedFinal reportBurkes BR-1 · Brigham City, UTA loss of engine power as a result of a failure of the primary and backup ignition system.NTSB GAA16CA347Accident · No injuriesData collectionFinal reportPiper PA 12 · Burnet, TXThe student pilot's failure to maintain adequate fuel levels, which resulted in fuel starvation, a loss of engine power, and a forced landing. Contributing to the accident was the flight instructor's failure to monitor the fuel levels.NTSB GAA16CA330Accident · Minor injuriesData collectionFinal reportCessna 152 · Clearlake Oaks, CAThe pilot's deviation from his original flight plan, which resulted in becoming lost in mountainous terrain at night, fuel exhaustion, loss of engine power, and a collision with power lines during a forced landing.NTSB CEN16LA231Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blaine, MNThe pilot's failure to maintain a proper airspeed during the landing approach, which resulted in an improper flare and hard landing.NTSB CEN16LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Humansville, MOA partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB GAA16CA361Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, OHThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB ERA16WA249Incident · No injuriesForeign investigationBeech B200 · Lima, PeruOn June 21, 2016, about 1939 coordinated universal time (UTC), a Beech 200C, Peruvian registration OB-2104-P, operated by Aerolinea Del Caribe Peru, sustained minor damage during a runway excursion, after landing on Runway 15 with a malfunctioning landing…NTSB DCA16WA194Incident · No injuriesForeign investigationBoeing 747 · Los Angeles, CAAustralian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 747 airplane that occurred on June 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB GAA16CA527Accident · No injuriesData collectionFinal reportSwearingen SA226 · Farmingdale, NYThe pilot-in-command’s failure to extend the landing gear before landing and his failure to use the Before Landing checklist. Contributing to the accident was the pilots’ failure to maintain a sterile cockpit during landing.NTSB GAA16CA341Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Freemont Island, UTThe flight instructor's failure to maintain directional control during the landing roll, resulting in an impact with an unknown object during aborted landing and consequent ground impact.NTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.NTSB ERA16LA224Accident · No injuriesLimited investigationFinal reportCessna 172P · Honesdale, PAThe pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…NTSB CEN16LA227Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Bowie, TXThe inadequate maintenance and inspection of the throttle control arm, which resulted in its in-flight separation and the subsequent loss of engine power.NTSB CEN16LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA 24 · Houston, TXThe total loss of engine power due to fuel exhaustion.NTSB WPR16FA126Accident · 1 fatalField investigationFinal reportPiper PA 23-150 · Hayward, CAThe failure of the left engine due to water contamination and the pilot's subsequent failure to maintain single-engine minimum control airspeed, which resulted in an uncontrolled descent. Contributing to the accident was the pilot's lack of total and recent…