NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ANC07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe malfunction of an engine magneto during cruise flight, which resulted in a partial loss of engine power, and an on-ground encounter with terrain. A factor associated with the accident was the high vegetation at the off-airport landing site.NTSB SEA07TA181Accident · No injuriesFinal reportMcDonnell Douglas DC 10-10 · Tehachapi, CAThe captain's failure to maintain clearance from trees.NTSB SEA07LA187Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fresno, CAThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB SEA07CA185Accident · Minor injuriesData collectionFinal reportHammer Thorp T-18 · Everett, WAExcessive airspeed during a return for landing which resulted in an overrun. An unlatched canopy, a proper touchdown point not attained and rough terrain were factors.NTSB SEA07CA183Accident · No injuriesData collectionFinal reportCessna 172N · Greenwater, WAThe in-flight encounter with a sudden windshift during the takeoff initial climb, to which the certified flight instructor responded by aborting the takeoff and landing off the end of the runway. The ditch was a contributing factor.NTSB NYC07CA150Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Machias, METhe pilot's inadequate in-flight planning.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.NTSB SEA07CA184Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 · La Pine, ORThe pilot's selection of an unsuitable landing site for a precautionary landing. Contributing factors were the pilot's failure to refuel the airplane, the low fuel level, and trees.NTSB SEA07CA182Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAThe pilot's improper recovery from a bounced landing which resulted in an inadvertent stall and a hard landing. The crosswind was a factor.NTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB DCA07WA053Accident · No injuriesForeign investigationBoeing B737-800 · Treviso, ItalyNTSB CHI07FA182Accident · 2 fatalField investigationFinal reportNorth American Navion · Colona, ILThe non-instrument rated pilot's continued flight into instrument meteorological conditions.NTSB CHI07CA186Accident · No injuriesData collectionFinal reportPiper J3F-65 · Grand Ledge, MIThe pilot's failure to maintain directional control during takeoff resulting in a ground loop.NTSB ATL07CA097Accident · Minor injuriesData collectionFinal reportSherman John, H Nieuport II · Binghamton, NYThe failure of the main gear spring during landing, which resulted in a loss of directional control, and a nose over.NTSB SEA07CA179Accident · Serious injuriesData collectionFinal reportCessna 170A · Bozeman, MTThe pilot's inadequate visual lookout and failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain while manuevering to avoid the transmission lines. The sun glare was a factor.NTSB NYC07LA148Accident · 2 fatalLimited investigationFinal reportSyracuse Vans RV-4 · Wallkill, NYThe pilot's improper decision to attempt low altitude aerobatics, and his failure to maintain airspeed during the aerobatics, which resulted in an inadvertent stall while maneuvering.NTSB LAX07CA193Accident · No injuriesData collectionFinal reportCessna 172S · Jacksonville, FLthe student pilot's failure to maintain directional control.NTSB DFW07WA180Incident · No injuriesForeign investigationBoeing 757 · Quito, EcuadorNTSB DEN07CA107Accident · Minor injuriesData collectionFinal reportTruitt Peter Zenair CH 701SP · Mountain View, WYThe pilot's failure to maintain aircraft control during cruise flight resulting in an impact with terrain. Contributing factors were the wind gust and high density altitude.NTSB CHI07LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Rio Creek, WIThe pilot's improper aircraft weight and balance, and his failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb.NTSB CHI07CA178Accident · No injuriesData collectionFinal reportAeronca 7EC · Hillsdale, MIThe aircraft control not maintained by the pilot during landing rollout.NTSB ANC07LA055Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Nenana, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop and main landing gear collapse. Factors contributing to the accident were the ground-loop and landing gear collapse.NTSB ANC07FA054Accident · 2 fatalField investigationFinal reportCessna 177RG · Wasilla, AKThe flight instructor's failure to adequately supervise the private pilot (dual student), and his delayed go-around during approach to land. Contributing to the accident was the dual student's misjudged distance/altitude.NTSB ANC07CA053Accident · No injuriesData collectionFinal reportGrumman G21A · Dutch Harbor, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a loss of directional control and a nose over.NTSB SEA07LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Flagstaff, AZThe loss of engine power during cruise flight due to fuel exhaustion, as a result of the pilot's failure to refuel and inadequate preflight planning.NTSB SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB ATL07CA098Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Coats, NCThe CFI's failure to maintain a visual look out while taxiing resulting in an on ground collision with a hole on the grass runway and collapse of the right main landing gear.NTSB ATL07CA096Accident · Minor injuriesData collectionFinal reportBurk RV-6A · Laurel, MDThe pilot's improper landing flare resulting in an inadvertent stall and hard landing, which resulted in the airplane sliding off the runway and nosing over.NTSB ATL07CA095Accident · Minor injuriesData collectionFinal reportZaverton Elmer PJ260 SR Aero Sport · Lehighton, PAThe failure of the pilot to maintain sufficient airspeed while maneuvering to avoid a stall, which resulted in an inadvertent stall/spin, and collision with trees and terrain.NTSB ANC07CA052Accident · No injuriesData collectionFinal reportCessna 175 · Stoney River, AKThe pilot's failure to maintain altitude/clearance during takeoff-initial climb, which resulted in the airplane colliding with a tree, and an uncontrolled descent.NTSB SEA07CA186Accident · No injuriesData collectionFinal reportCessna 182 · Bear Lake, IDThe separation of the bolt that holds the nosewheel steering torque arm to the nose wheel strut during the takeoff roll, resulting in no nosewheel steering being available during the landing roll at the pilot's destination. Factors include the pilot's failure…NTSB SEA07CA176Accident · Minor injuriesData collectionFinal reportCommonwealth 185 · Redlands, CAThe pilot's inadequate weather evaluation which resulted in the airplane's lack of climb performance and subsequent collision with terrain. Contributing factors included the downdraft and the high temperature.NTSB NYC07LA147Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8GCBC · Sanford, FLThe pilot's failure to maintain airspeed and his excessive pitch attitude while maneuvering.NTSB MIA07LA111Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Cullman, ALThe pilot’s mismanagement of an in-flight emergency, which resulted in a gear-up landing and runway overrun. Contributing to the accident was a breach to the engine crankcase above and in line with the No. 1 cylinder.NTSB DFW07CA145Accident · No injuriesData collectionFinal reportEvektor sportstar · Grand Prairie, TXLoss of control due to an unexpected crosswind gust. *This report was modified on May 23, 2008.*NTSB DEN07CA105Accident · Minor injuriesData collectionFinal reportPiper PA-32-301T · Santa Fe, NMThe pilot's inadequate preflight planning and preparation, and improper in-flight decisions resulting in fuel exhaustion. A factor was the unsuitable terrain for landing.NTSB DEN07CA103Accident · No injuriesData collectionFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to maintain airspeed on approach resulting in the stall and subsequent impact with terrain.NTSB CHI07FA176Accident · 1 fatalField investigationFinal reportBeech A36TC · Cannon Falls, MNThe pilot's continued flight into instrument meteorological conditions, which resulted in spatial disorientaton and loss of control.NTSB NYC07FA145Accident · 2 fatalField investigationFinal reportCessna 182C · Hiddenite, NCCarburetor icing, which resulted in a loss of engine power. Also causal, was the pilots' failure to maintain airspeed during the forced landing, which resulted in an inadvertent stall.NTSB MIA07WA110Accident · No injuriesForeign investigationPiper PA-28-161 · Atlantic OceanNTSB DEN07CA102Accident · Minor injuriesData collectionFinal reportEagle RND Helicycle · Erie, COThe pilot's failure to maintain aircraft control resulting in the helicopter impacting onto the airport ramp. A contributing factor to the accident was the pilot's failure to establish the landing flare in time.NTSB ATL07CA094Accident · No injuriesData collectionFinal reportCessna C152 · Miami, FLThe pilot's loss of consciousness while on final approach to land, resulting in an uncontrolled descent, and a hard landing on the runway.NTSB SEA07TA174Accident · No injuriesFinal reportCessna 185C · Kalispell, MTThe complete loss of engine power during an attempted go-around from a simulated engine-out landing. Factors include rough/uneven terrain and high vegetation where the pilot made an emergency forced landing.NTSB NYC07LA146Accident · No injuriesLimited investigationFinal reportBell-Carson 47G-Super C-4 · Wall Township, NJA total failure of the number one connecting rod during approach.NTSB DFW07CA143Accident · Minor injuriesData collectionFinal reportBell BH206B-3 · Sand Springs, OKThe pilot's failure to maintain clearance with ground obstacles, which resulted in a blade strike. A contributing factor was the low altitude selected by the pilot.NTSB DFW07CA142Accident · No injuriesData collectionFinal reportCessna 206 · Baton Rouge, LAFuel starvation as result of the pilot's failure to properly position the fuel selector. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07LA101Accident · No injuriesLimited investigationFinal reportBeech 1900D · Laramie, WYThe pilot's improper decision, his misjudgment of his speed and distance, and his failure to perform a go-around resulting in the airplane overrunning the runway and striking an electrical box. Factors contributing to the accident were the failure of the crew…