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 CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.NTSB CHI93LA328Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Wilber, NEthe loss of engine power for an undetermined reason.NTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.NTSB CHI93LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Millard, NEImproper maintenance/inspection of the aircraft by (other) maintenance personnel, and subsequent blockage of the induction air system by an object (alternate air door) that was not removed during previous maintenance.NTSB CHI93FA302Accident · 5 fatalField investigationFinal reportRockwell 690-A · Norfolk, NEThe failure of the pilots of the Rockwell 690-A, N707BP, and the Piper PA-28R, N33056, to see and avoid each other. A factor which contributed to the accident was the failure of both pilot's to follow recommended communication procedures contained in the…NTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.NTSB CHI93LA177Accident · 1 fatalLimited investigationFinal reportCessna 120 · Crawford, NEThe pilot's failure to maintain adequate airspeed.NTSB CHI93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot's selection of unsuitable terrain on which to land and his excessive use of brakes.NTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.NTSB CHI93FA165Accident · 3 fatalField investigationFinal reportCessna 182N · Genoa, NEThe private pilot's failure to maintain clearance from terrain while attempting aerobatic maneuvers. The pilot's disregard for procedures/directives, and attempted aerobatics, are factors.NTSB CHI93MA143Accident · 2 fatalMajor investigationFinal reportBeech C99 · Shelton, NEThe deliberate disregard for the federal aviation regulations, gp express procedures, and prudent concern for safety by the two pilots in their decision to execute an aerobatic maneuver during a scheduled check ride flight, and the failure of gp express…NTSB CHI93FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Plattsmouth, NEThe pilot-in-command (CFI)'s failure to maintain airspeed.NTSB CHI93LA117Accident · No injuriesLimited investigationFinal reportCessna 150J · Hastings, NEThe pilot's failure to refuel the airplane en route which resulted in an inadequate fuel supply for the flight.NTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.NTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.NTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.NTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.NTSB CHI93LA041Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Mccook, NEThe pilot's improper decision to depart in known adverse weather conditions. The icing conditions and structural ice were factors.NTSB CHI93FA024Accident · 2 fatalField investigationFinal reportCessna U206F · Valentine, NEThe pilot-in-command's intentional flight into an area of low ceilings, and his failure to maintain an altitude sufficient for terrain clearance. Factors which contributed to the accident were: the pilot's overconfidence, the low ceiling and the dark night…NTSB CHI93LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Weeping Water, NEThe pilot's failure to maintain directional control.NTSB CHI92LA296Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Plattsmouth, NEThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control.NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.NTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.NTSB CHI92TL#02Accident · No injuriesClass 3Final reportSikorsky S-58ET · North Platte, NENTSB CHI92LA241Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Valentine, NEThe pilot's failure to maintain adequate airspeed. Factors related to the accident were the weather obscuration and failure to attain proper runway alignment.NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.NTSB CHI92LA229Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenwood, NEThe private pilot's poor in-flight planning and decision making.NTSB CHI92LA225Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Whitman, NEWater contamination in the fuel and low magneto output.NTSB CHI92DCJ04Accident · No injuriesFinal reportCallair A-9 · Beaver City, NEThe inadequate maintenance overhaul of the left magneto, and subsequent failure of the left magneto/ignition system which caused a complete loss of engine power.NTSB CHI92LA190Accident · No injuriesLimited investigationFinal reportPitts S2B · Aurora, NEThe pilot-in-command's restricted visual lookout from smoke entering the cockpit. Factors were smoke in the cockpit which resulted in the pilot becoming disoriented.NTSB CHI92FA145Accident · 3 fatalField investigationFinal reportPiper PA-18 · Arnold, NEThe pilot's failure to maintain airspeed. Factors in the accident were improper adjustment of the carburetor float level by an unknown person, and the pilot's disregarding weight-and-balance.NTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…NTSB CHI92DCJ03Accident · No injuriesFinal reportSchweizer G-164B · Scotia, NEThe pilot's failure to maintain aircraft control which resulted in a nose over during the precautionary landing. Related factors are the power lines (obstructions) and inadequate altitude.NTSB CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.NTSB CHI92DCJ02Accident · 2 fatalFinal reportExtra Flugzeugbau 300 · Grant, NEThe pilot's inadequate aircraft control while performing aerobatic maneuvers.NTSB CHI92LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEThe pilot's inadequate compensation for the wind conditions. Associated factors are the high and gusty winds.NTSB CHI92DCJ01Accident · 2 fatalFinal reportPiper PA-18-125 · Ashby, NEThe pilot's failure to maintain aircraft control while maneuvering.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB CHI91LA273Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Columbus, NEImproper refueling by ground personnel and the pilot's inadequate preflight.NTSB CHI91DCJ08Accident · No injuriesFinal reportCessna 188B · Belgrade, NEThe pilot's failure to take adequate remedial action. A related factor is the premature liftoff.NTSB CHI91DCJ07Accident · No injuriesFinal reportPiper PA-25-150 · Stapleton, NEThe pilot's disregard for aircraft performance data. Related factors are the pilot's poor weather evaluation, and delayed remedial action.NTSB CHI91DCJ06Accident · 1 fatalFinal reportCessna A188D · Gothenburg, NEThe pilot's failure to maintain airspeed which resulted in a stall. A factor related to the accident was the pilot's abrupt handling of the airplane.NTSB CHI91FA259Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Guide Rock, NESpatial disorientation, and exceeding the design limits of the aircraft. Factors related to the accident are inadequate preflight planning, VFR flight into IMC, flight weather avoidance assistance not followed, excessive altitude, physical impairment…NTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.NTSB CHI91DCJ05Accident · No injuriesFinal reportMcdonnell Douglas 269A · Harvard, NEThe pilot's failure to maintain adequate rotor RPM during aerial application maneuvers. A related factor was the pilot's inattention.NTSB CHI91DCJ04Accident · No injuriesFinal reportCessna T188C · Grand Island, NEThe pilot's failure to maintain adequate clearance from crops during aerial application maneuvers. Related factors are the failure of a propeller pitch change mechanism and the pilot's diverted attention.NTSB CHI91DCJ03Accident · No injuriesFinal reportGrumman G-164-A · Edgar, NEThe pilot's inadequate aircraft preflight inspection.NTSB CHI91LA189Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Wausa, NEThe pilot's delayed decision to turn around after encountering IFR flight conditions. Factors were restricted forward visibility and power lines.NTSB CHI91LA158Accident · No injuriesLimited investigationFinal reportCessna 180 · Scottsbluff, NEFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident were a crosswind condition and lack of total experience in type of aircraft by the pilot.