NTSB investigations, NE
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA' 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" = 'NE' AND c."eventCountry" = 'USA' 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 CHI02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · O'Neill, NEThe inadequate preflight planning by the pilot resulting in the exhaustion of the fuel supply, and the pilot not maintaining directional control during the forced landing. A factor was the unsuitable landing area selected by the pilot, and the ditch.NTSB CHI02LA026Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Wahoo, NEThe pilot's inadequate preflight planning/preparation resulting in fuel exhaustion during cruise flight, and the unsuitable terrain for landing encountered by the pilot during the subsequent forced landing. Factors relating to the accident were the pilot's…NTSB CHI02LA010Accident · No injuriesLimited investigationFinal reportBeech 58P · Columbus, NEThe exceeded aircraft performance and inadequate preflight planning/preparation by the pilot in command. The lack of recent experience in aircraft by the pilot in command was a contributing factor.NTSB CHI01LA286Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Petersburg, NEThe failure of the engine cylinder, and the unsuitable terrain for landing encountered by the pilot. Factors were the low altitude and the muddy field.NTSB CHI01LA263Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Callaway, NEFuel exhaustion due to the pilot's inadequate preflight. Contributing to the accident was the muddy field and the unsuitable terrain encountered during the forced landing.NTSB CHI01IA246Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Kenesaw, NEThe propeller blade fatigue leading to its tip separating during an aerial application. Factors were no suitable terrain for an emergency landing, high vegetation, and soft terrain encountered during the emergency landing.NTSB CHI01LA242Accident · No injuriesLimited investigationFinal reportAg-Cat G-164B · Wallace, NEThe inadequate preflight planning by the pilot, the pilot initiating the flight with an inadequate fuel supply, and the unsuitable terrain encountered during the forced landing. Factors were the fuel exhaustion, the low altitude and the soft field.NTSB CHI01LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hastings, NEAircraft control not being maintained by the pilot which resulted in the encountered settling with power flight condition during the initial climb. Factors to the accident were the reported variable winds during the takeoff and the corn crop.NTSB CHI01LA219Accident · No injuriesLimited investigationFinal reportCessna 172C · Grand Island, NEThe procedures for using carburetor heat not followed by the student pilot and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing conditions, the carburetor icing, the student pilot's lack of…NTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.NTSB CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.NTSB CHI01LA173Accident · No injuriesLimited investigationFinal reportCessna 172S · Cambridge, NEthe pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…NTSB CHI01LA122Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Kimball, NEThe pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.NTSB CHI01LA121Accident · No injuriesLimited investigationFinal reportCessna 182L · Stromsburg, NEthe inadequate in-flight planning/decision and the flight to a destination alternate not performed by the pilot. Contributing factors were the crosswind and gusts.NTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.NTSB CHI01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Overton, NEThe open exhaust valve. Factors relating to the accident were the sticking exhaust valve guide and the snow drift the airplane encountered during the precautionary landing.NTSB CHI01LA090Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Scottsbluff, NEthe checklist not followed and the wheels-up landing performed by the pilot. The runway light was a contributing factor.NTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.NTSB CHI01LA065Accident · No injuriesLimited investigationFinal reportLuscombe 8E · North Platte, NEThe inadvertent ground loop. Factors associated with the accident were the pilot selected the wrong runway on which to land, the quartering tailwind, the icy runway, and the snow bank which the airplane contacted.NTSB CHI01FA017Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Homer, NEThe inadequate remedial action the flightcrew had during the stall recovery maneuver and the flight instructor's inadequate supervision. A factor was the intentional stall the flightcrew was performing.NTSB CHI00LA301Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Valentine, NEthe delayed aborted takeoff. Factors relating to this accident were the pilot's inadequate planning/preparation for the flight, the high density altitude, and the ditch.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB CHI00LA271Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Superior, NEthe cracked number 7 cylinder exhaust valve. A factor relating to this accident was the tree.NTSB CHI00LA267Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · North Platte, NEthe brake fire while taxiing for undetermined reasons.NTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.NTSB CHI00LA247Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Wallace, NEthe fractured number three exhaust push rod assembly and the unsuitable terrain encountered by the pilot.NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.NTSB CHI00LA204Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Holstein, NEthe settling with power encountered by the pilot. A factor was the sudden windshift.NTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.NTSB CHI00LA181Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Champion, NEthe undetermined uncontrolled descent.NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.NTSB CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB CHI00LA046Accident · No injuriesLimited investigationFinal reportCessna 150B · Omaha, NEThe pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.NTSB CHI00LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Raymond, NEthe pilot's lack of recent experience in the type of aircraft and type of operation, and the pilot not maintaining directional control. A finding was the glassy condition of the water.NTSB CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.NTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB CHI99LA272Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · North Platte, NEThe pilot's improper inflight planning decision which resulted in fuel exhaustion. A factor associated with the accident was the dark night conditions.NTSB CHI99FA267Accident · 1 fatalField investigationFinal reportAir Tractor AT502B · Giltner, NEThe pilot's inadequate visual lookout, and his failure to maintain clearance from the guy wire. A factor was the guy wire.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB CHI99LA192Accident · Minor injuriesLimited investigationFinal reportRussell Sport Trainer · Ft. Calhoun, NEthe pilot used an improper engine starting procedure in that he failed to reduce the throttle setting and to assure the airplane was adequately secured prior to starting.NTSB CHI99LA175Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · North Platte, NEThe pilot failed to maintain directional control during takeoff.NTSB CHI99LA137Accident · 2 fatalLimited investigationFinal reportBerrick GP-4 · Plattsmouth, NEaircraft control and airspeed not maintained by the pilot-in-command. A factor to the accident was the inadvertent stall.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB CHI99LA128Accident · No injuriesLimited investigationFinal reportCessna T-188C · Dalton, NEthe improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.