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 CHI99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the gusty, high, wind conditions, and the pilot's continued flight into adverse weather.NTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB CHI99LA080Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Alliance, NEthe unsuitable terrain for landing selected by the pilot-in-command. Factors were the tailwind landing condition and excessive braking by the pilot-in-command.NTSB CHI99LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Hyannis, NEthe pilot's failure to maintain clearance with the transmission line. Factors associated with the accident were the transmission line, the low altitude at which the pilot was flying, and his diverted attention to a person on the ground.NTSB CHI99LA057Accident · No injuriesLimited investigationFinal reportMooney M20E · Tryon, NEother maintenance personnel's not correcting a loose cylinder assembly. Factors were loose engine cylinder assembly, fractured cylinder mounting hardware, the roadway, and road sign.NTSB CHI99LA050Accident · No injuriesLimited investigationFinal reportCessna 310 · Ashland, NEthe pilot's not refueling the airplane to avoid fuel exhaustion, and his inadequate preflight planning. A factor was fuel exhaustion.NTSB CHI99LA046Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Naponee, NEthe pilot's failure to identify the wires prior to spraying the field and the low altitude at which the pilot was flying. A factor was the wires which the airplane contacted.NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB CHI99LA006Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Oshkosh, NEthe pilot's failure to maintain control of the helicopter. Factors associated with the accident were the high winds, low altitude at which the pilot was maneuvering and the uneven terrain which the helicopter contacted.NTSB CHI98LA322Accident · No injuriesLimited investigationFinal reportFairchild 24R-46A · Scribner, NEthe inadvertent ground loop caused by an unknown person who was in the process of stealing the airplane.NTSB CHI98LA317Accident · No injuriesLimited investigationFinal reportBeech C23 · North Platte, NEthe pilot's not compensating for wind conditions and failure to maintain control of the aircraft. A factor was the crosswind.NTSB CHI98LA312Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Shelton, NEThe pilot mismanaged the fuel which led to fuel starvation and subsequent loss of engine power.NTSB CHI98LA304Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Trenton, NEthe pilot misjudged the forced landing approach and stalled the airplane while attempting to lengthen his glide on final approach and inadequate preflight planning that led to the loss of engine power due to fuel exhaustion.NTSB CHI98LA272Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Falls City, NEthe main landing gear leg fracturing and separating from the portion mounted to the fuselage for undetermined reasons.NTSB CHI98LA262Accident · Serious injuriesLimited investigationFinal reportAeronca 11BC · Blue Springs, NEthe pilot's inadequate visual outlook to avoid impact with a wire. Factors were sunglare and the wire (static).NTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.NTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.NTSB CHI98LA196Accident · No injuriesLimited investigationFinal reportCessna 172K · Omaha, NEThe aircraft modification not being in compliance with the Supplemental Type Certificate. A factor to the accident was the fracture of the landing gear axle during landing.NTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.NTSB CHI98LA190Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Lexington, NEAn improper autorotation by the pilot in command. Factors contributing to this accident were the accumulation of ice in the carburetor resulting in a total loss of engine power, and the soft terrain.NTSB CHI98LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEthe pilot's failure to maintain control of the aircraft. Factors were the crosswind and runway light.NTSB CHI98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Norfolk, NEthe pilot's misjudged wind conditions and his not obtaining/maintaining compensation for wind conditions. A factor was a sudden wind shift.NTSB CHI98LA180Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Orleans, NEthe pilot selected a field with unsuitable terrain and stalled the airplane. Additional factors were the tower in the field, and engine failure due to the improper torque applied to camshaft bolts by other maintenance personnel.NTSB CHI98LA178Accident · Minor injuriesLimited investigationFinal reportCessna 414 · North Platte, NEthe slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.NTSB CHI98LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Lincoln, NEthe pilot of N60BH failed to maintain clearance with N11498. Factors associated with the accident were the diminished visual lookout due to the runway and the tail wheel configuration of N60HB, along with the controllers failure to point out traffic.NTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.NTSB CHI98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Omaha, NEThe fatigue failure of the crankshaft which resulted from a spun bearing and the low altitude at which the loss of engine power occurred. A factor in the accident was the embankment on which the airplane was landed.NTSB CHI98LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Superior, NEthe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the sign which the airplane contacted and inadequate preflight planning/preparation.NTSB CHI98LA094Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Wood Lake, NEthe pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings.NTSB CHI98LA084Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Island, NEice build-up on the airplane's wings and empennage which led to an inadvertent stall and hard landing. Factors contributing to this accident were the pilot's inadvertent flight into icing conditions, and the icing conditions.NTSB CHI98LA072Accident · 1 fatalLimited investigationFinal reportPiper PA-30/A · Hastings, NEThe pilot's improper IFR procedure, by which he failed to maintain minimum descent altitude. Fog, a low ceiling, and night condition were a contributing factor.NTSB CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.NTSB CHI98LA047Accident · No injuriesLimited investigationFinal reportHall RV-6 · Blair, NEa fatigue failure of the torque tube outside of the weld and the fractured pilot's side left rudder pedal.NTSB CHI98LA046Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Lincoln, NEthe throttle linkage coming apart in flight, and the inadvertent stall.NTSB CHI98LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Liberty, NEA loss of engine power for undetermined reasons.NTSB CHI98FA010Accident · 3 fatalField investigationFinal reportAero Commander 100-180 · Auburn, NEthe pilot misjudged distance/altitude to the runway, while on final approach to land, allowing the airplane to get too low and collide with a truck. A related factor was: the proximity of the truck (and highway) to the runway.NTSB CHI98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Nebraska City, NEthe pilot's improper positioning of the fuel slector to a tank which contained only unusable fuel.NTSB CHI97LA259Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bradshaw, NEthe pilot not maintaining clearance from the terrain. Factors contributing to this accident were the pilot's diverted attention due to the problems with his global positioning flagger equipment and the other ag- airplane, and the crop.NTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…NTSB CHI97LA235Accident · No injuriesLimited investigationFinal reportCessna A188A · Norfolk, NEthe pilot's improper in-flight planning/decision, and failure or inability to control the airplane after encountering wake turbulence at low altitude during an aerial application maneuver. A related factor was the low altitude of the airplane when the wake…NTSB CHI97LA226Accident · No injuriesLimited investigationFinal reportBeech D50A · Mitchell, NEthe pilot's improper fuel selector position and the fuel starvation. Factors contributing to the accident were: the pilot's inattentiveness of the refueling, inadequate aircraft preflight, and the rough terrain/ditch.NTSB CHI97LA223Accident · No injuriesLimited investigationFinal reportCessna 188B · Adams, NEinadequate maintenance/annual inspection, and subsequent exhaustion of hydraulic (brake) fluid, which resulted in loss of braking action (right brake) and impact with a tree. The proximity of tree(s) was a related factor.NTSB CHI97LA209Accident · No injuriesLimited investigationFinal reportPiper PA-25-235A · O'Neil, NEfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel consumption calculations. Factors relating to the accident were: the lack of an operable fuel indication system, and the high winds.NTSB CHI97LA158Accident · No injuriesLimited investigationFinal reportKohles Kitfox III · Meadow Grove, NEfailure of the pilot to maintain directional control of the airplane during an aborted takeoff. A factor was the pilot's lack of recent experience in the make and model of airplane.NTSB CHI97LA046Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Hayes Center, NEinadequate fuel management by the pilot, which resulted in fuel starvation. The factors relating to the accident were: a fuel leak at the engine driven fuel pump, and the engine driven fuel pump pressure was too low.NTSB CHI97LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Alliance, NEthe instructor-pilot's inadequate supervision by not taking timely action after the student started losing directional control. A factor was the loss of directional control by the student pilot.NTSB CHI97LA006Accident · Minor injuriesLimited investigationFinal reportCallair B1A · Nebraska City, NEa supercharger bearing failure. A factor was the excessive sink rate during the forced landing.