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 ANC88LA070Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Black Lake, AKThe pilot attempted a landing at a mining strip which was 1000 feet long. The pilot overshot the runway touchdown point; he then attempted a go-around, lost control , and crashed 300 feet off the departure end of the runway.NTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.NTSB LAX88DVA07Accident · 1 fatalFinal reportAyres S2R · Firebaugh, CADuring an agricultural spraying run, the airplane was required to fly under power lines to complete the job. The airplane was seen flying in the direction of the wires. The airplane initially contacted a levee with the wing and then collided with a power…NTSB FTW88LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Clifton, TXThe student pilot was on her third landing during her first solo flight. The pilot reported that she lost control and the airplane ground looped during the landing roll.NTSB DEN88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDNTSB ATL88LA197Accident · Serious injuriesLimited investigationFinal reportAeronca 0-58B · Newberry, SCThe pilot related that he had been flying around the local area making landings at various airports for about 1 1/2 hours. He returned to the departure airport and made a full stop landing. His 12 year old son requested that he make another takeoff and…NTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.NTSB SEA88LA115Accident · Minor injuriesLimited investigationFinal reportPeterson J-4 · Ephrata, WAThe glider plt was maneuvering for a thermal when he encountered a downdraft. The plt said insufficient altitude remained for an airport landing. An off-airport landing on rough terrain resulted in damage to the glider.NTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…NTSB MIA88FA201Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Catano, PRAs the acft was taxiing for takeoff, witnesses noted the l rear baggage door was unlocked & hanging down. A warning was relayed to the plt via the twr, but by then the acft was airborne & the plt had rprtd a control prblm. Drg lift-off, theacft pitched up…NTSB LAX88LA228Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Clearlake, CAThe pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane…NTSB LAX88LA227Accident · No injuriesLimited investigationFinal reportCessna 210M · Tres Pinos, CANTSB LAX88LA205Accident · No injuriesLimited investigationFinal reportCessna 150J · Calistoga, CANTSB LAX88DVG05Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CANTSB CHI88LA136Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC2-MK I · Warroad, MNThe pilot decided to land in the lake approximately 1000 yds from the sea plane base and was attempting a step-taxi back to the base when the acft struck a sand bar. The pilot stated that he was taxiing near tall grass where he thought the water was deep…NTSB CHI88DER10Accident · No injuriesFinal reportAnderson-Tucker Evans VP-1 · Duquette, MNOn the initial flight of this amateur built aircraft the pilot lowered the nose after liftoff to allow the aircraft to accelerate. However, the aircraft settled and the pilot was unable to keep the aircraft from colliding with trees.NTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.NTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.NTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…NTSB MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…NTSB LAX88LA225Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Santa Barbara, CANTSB DEN88LA132Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Moriarty, NMThe pvt glider plt was completing a five hr endurance flight. During the turn from base to final, the glider encountered a 15 kt xwind and overshot the turn. The plt attempted to 'buttonhook' back toward the intended touchdown point. Witnesses stated that…NTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…NTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.NTSB SEA88FA113Accident · Minor injuriesField investigationFinal reportBeech 58P · Bellevue, WAThe plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the…NTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…NTSB NYC88LA169Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Copake Falls, NYDuring a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation…NTSB NYC88LA168Accident · No injuriesLimited investigationFinal reportCessna 305A · Colts Neck, NJDuring a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…NTSB NYC88FA167Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Livermore Falls, METhe citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…NTSB MKC88LA112Accident · No injuriesLimited investigationFinal reportBeech D18S · St. Louis, MOArriving at his destination airport after a night 14 CFR 135 air taxi cargo flight, the main landing gear collapsed during roll-out causing substantial damage to the aircraft. Post accident investigation revealed a broken landing gear drag link, which caused…NTSB MIA88FA197Accident · 1 fatalField investigationFinal reportKennedy Skycycle 2 · Orlando, FLThe gyroplane was on a local demonstration flt. The passenger (pax) stated the plt took off, climbed to aprx 500 ft AGL,descended to aprx 20 ft AGL & maneuvered near observers. He said the plt then added power & initiated a 30 deg climb attitude. The pax…NTSB LAX88DVA08Accident · Serious injuriesFinal reportSmith Model B Avid Flyer · Atwater, CADuring a local test flight, just after takeoff, the engine suddenly lost power and went to idle. The pilot made an off airport landing without incident. The pilot inspected the engine finding nothing unusual. The pilot attempted another takeoff to return to…NTSB DEN88LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ayr, NDNTSB CHI88DEC03Accident · Minor injuriesFinal reportCessna 150 · Jackson, MITotal loss of engine power due to carburetor icing.NTSB BFO88LA055Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Capon Bridge, WVLoss of power because of carburetor ice which obstructed airflow to the engine. The aircraft nosed over on landing because of soft terrain and high grass. The pilot's failure to use carburetor heat is a contributing factor.NTSB SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.NTSB NYC88FA166Accident · 2 fatalField investigationFinal reportBell 206L-1 · Springtown, PAWhile in cruise flight, ground witnesses observed the helicopter make two violent roll maneuvers followed by an in-flight breakup. Aircraft wreckage was spread over an area of approximately 10 acres. Examination of the wreckage revealed that the collective…NTSB MIA88WA194Incident · No injuriesForeign investigationBoeing 747-100 · CuracaoNTSB MIA88IA196Incident · No injuriesIncident investigationFinal reportLearjet 24 · W. Palm Beach, FLThe acft departed fort lauderdale executive arpt on a 14 CFR part 91 positioning flight to pick up a patient in west Palm Beach FL, for a 14 CFR part 135 air ambulance flight to rochester new york. The plt stated that on landing the acft floated aprx 4000…NTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…NTSB LAX88LA226Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-100 · Tau, AntarcticaThe captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…NTSB FTW88LA122Accident · No injuriesLimited investigationFinal reportCessna 182R · Garden City, TXThe pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…NTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.NTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…NTSB BFO88LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Reedville, VAAfter back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the…NTSB ANC88LA150Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Mekoryuk, AKThe pilot-in-command was herding reindeer for a native corporation and he and his passenger had to relieve themselves so they landed on the tundra and left the helicopter's engine and rotors operating. As they were exiting the helicopter, it shifted on the…NTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…NTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…NTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…NTSB ATL88DKG08Accident · No injuriesFinal reportSikorsky S-55B · Valdosta, GA