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 MIA84LA061Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Pensacola, FLDuring takeoff, the eng began losing power at about 200 ft AGL. The plt applied carb heat & began a descent. Power was restored for about 5 sec, then all power was lost. The acft was landed straight ahead in a wooden swampy area & was substantially damaged.…NTSB FTW84LA116Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Vencie, LAAccording to the plt, he took off from a came site to pick up duck hunters at several locations. During the flt, he encountered fog & turned toward venice, LA to land. He then saw an oil field structure & some land & elected to make a precautionary landing.…NTSB DCA84AA014Accident · Serious injuriesFinal reportFokker F27-100 · Jamaica, NYDuring the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…NTSB NYC84LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Seneca Falls, NYDuring the landing rollout the acft hit an icy patch of rwy and at the same time encountered a gusty crosswind. The acftskidded into a snowbank and nosed over.NTSB MIA84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 411A · Gainsville, FLThe acft crashed while on a ILS approach to the Gainsville, airport. Investigation revealed that the plt had advised approach control that he was 'low on fuel.' After two missed approaches the plt radioed that he was 'out of fuel.' The plt did not have charts…NTSB MIA84FA058Accident · 1 fatalField investigationFinal reportHiller UH-12C · San Juan, PRA performer fell from a trapeze rigged below the helicopter while it was hovering at about 150 ft AGL. The FAA had not authorized the modification to the acft. The plt was not certified for external load operations. The performer reportedly had not done this…NTSB LAX84FA138Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Tracy, CAThe flight departed under instrument meteorological conditions, with visibility restricted to one quarter mile by fog. The ceiling was obscured. After departure witnesses heard the aircraft make what appeared to be a left turn. Next they heard the engine…NTSB FTW84LA117Accident · No injuriesLimited investigationFinal reportCessna 120 · Jayton, TXThe acft nosed over during landing. The plt said he was trying to correct a veer in the tail wheel acft and may have inadvertantly used the right brake.NTSB ATL84FA080Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Basye, VAAfter the acft landed, slush was observed to have accumulated under the wings & lower aft fuselage & was freezing. The acft was parked with the tail facing the sun, but none of the arpt personnel noticed whether the sun had melted the ice. The plt indicated…NTSB ANC84LA030Accident · No injuriesLimited investigationFinal reportCessna 206 · Wasilla, AKThe acft crashed into a heavely wooded area after encountering IMC weather conditions and losing power on the engine. Heavy icing and freezing rain were reported in the area. The plt stated that he could not maintain VFR conditions on top due to raising cloud…NTSB LAX84LA139Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Montague, CAThe acft veered off the rwy and nosed over during landing. The plt acknowledged that there was no wind and the acft was 'flying ok.' He said he just lost control and ground looped.NTSB LAX84LA137Accident · No injuriesLimited investigationFinal reportRockwell 114 · Las Vegas, NVThe acft veered off the rwy in a strong gusty crosswind. As the acft left the rwy the landing gear collapsed. The plt stated that she over-corrected having never attempted a takeoff in wind that strong.NTSB LAX84FA136Accident · 1 fatalField investigationFinal reportCessna 185 · Union City, CAThe acft crashed into hilly terrain in an almost vertical high speed power on descent. A witness about 64 miles north of the accident site had seen an acft that met the description of the accident acft 'scud running', or flying beneath the low cloud bases…NTSB FTW84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Albuquerque, NMThe pilot made an emergency landing after a total power loss. Prior to the total loss there had been approximately four drops in manifold pressure. The gear collapsed on landing, bending the engine mounts & both wing spars. The subsequent investigation…NTSB FTW84FA114Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Throckmorton, TXThe acft crashed in a steep left wing down, nose down attitude. The flt had been for the purpose of checking out the front seat plt on pipe line patrol. The front seat plt had only 22 hrs in this make & model. The weather was VMC and no mechanical…NTSB CHI84LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIThe student plt lost control of the acft on a snowy rwy and collided with a snowbank. The student added power for takeoff after a touch and go landing and the acft veered to the left. The acft was not corrected before a collision witha snowbank occurred. This…NTSB MKC84MA060Accident · 1 fatalMajor investigationFinal reportDouglas DC-3C · St. Louis, MOAfter landing, the plt-in-command (PIC) placed a refueling order to fill the acft's two 210 gal main tanks for a return flt to toronto, ontario, Canada. After the cargo was unloaded & the acft was refueled, the aircrew aborted the 1st 2 attempts to takeoff…NTSB LAX84IA153Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-30 · Los Angeles, CAAn aeromexico DC-9 encountered wake turbulence from a twa L-1011 on the approach to rwy 24L. The aeromexico acft was 6 miles (1 min & 10 sec) behind the twa acft & 800 ft below its glideslope at 6100 ft when the incident occurred.NTSB FTW84LA416Accident · 1 fatalLimited investigationFinal reportCessna 210N · Plaquemine, LAThe acft was found by a hunter crashed in a heavily wooded swamp area aprx 10 months after the acdnt. The sole body fnd was beyond a condition of testing for toxicology or autopsy. The body was identified as a plt who was supposed to meet the owner of the…NTSB FTW84LA112Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Okemah, OKThe plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy.NTSB DEN84LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Angel Fire, NMAfter making a x-country flt from Oklahoma city, ok to Angel Fire, NM, the plt landed on a snow covered rwy at an elevation of 8382 ft. during the landing, the acft bounced, drifted to the left side of the rwy, then hit a 3-1/2 ft snowbank. The plt reported…NTSB DEN84LA069Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Alamosa, COThe plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft…NTSB CHI84LA091Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Chicago, ILThe acft was being taxied from landing. At a service road intersection a baggage tug collided with the right wing. The acft lights were reportedly on at the time of the accident. The driver of the tug said he was not looking for a small acft on the taxiway,…NTSB CHI84LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-33A · Crystal, MNThe acft collided with trees and a residence near the destination airport after experiencing a total non-mechanical loss of power resulting from fuel starvation. The pilot reported he had estimated the fuel on board by a visual inspection of the tanks. This…NTSB NYC84FHM06Accident · Serious injuriesFinal reportCessna 210N · Millbrook, NYPlt was injured while hand propping the acft.NTSB MKC84LA061Accident · No injuriesLimited investigationFinal reportPiper J-3 · Battle Creek, NEThe acft as taxiing on a hard packed snow covered field when the right main landing gear collapsed. Visual inspection did not show any signs of fatigue. Slight bending and overload separtion of the shock strut tubing was evident.NTSB FTW84LA111Accident · No injuriesLimited investigationFinal reportCessna T210N · Waring, TXDuring flt in IMC conditions, the alternator became inoperative. Subsequently, the acft lost electrical power, but the plt had gotten into VMC conditions. He elected to land on a private grass strip. He reported that his apch speed was too fast, he landed…NTSB DEN84LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · Custer, SDThe acft collided with a snow berm during landing and nosed over. The plt said they were hit by a wind shear crosswind from a valley 90 degrees to the rwy.NTSB CHI84LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · East St. Louis, ILThe pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the…NTSB MKC84LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Elkader, IAThe acft nosed over during landing on a snow-covered rwy after striking a snow drift. The plt said he did not see any tracks in the snow covered rwy but since there was no NOTAM closing the arpt he went ahead with a soft field landing. He said the snow…NTSB MIA84LA057Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Eustis, FLThe plt stated that she attempted to make a low downwind turn to final from approximately 300 ft AGL and the acft encountered a roll effect over some pine trees on the west side of the rwy. The left wing tip struck the ground and pulled the nose into the…NTSB CHI84LA083Accident · No injuriesLimited investigationFinal reportCessna 150M · Pittsboro, INThe acft made a forced landing on a rough, snow covered field after the engine failed. Post accident investigation showed thet the exhaust valve on #1 cylinder punctured the cylinder.NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.NTSB ATL84FU003Accident · 1 fatalFinal reportPterodactyl Ascender II · Lawrenceville, GAThe plt took off in conditions of turbulence & gusty winds. Witnesses reported the ultralight vehicle pitched & rolled erratically after lift-off. The plt then made a right climbing turn to a downwind heading & proceeded over a tall tree line toward a field…NTSB ANC84LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe plt stated that at the time of the accident, he encountered a white out condition. The acft stalled and crashed on ahillside.NTSB SEA84IA037Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Seattle, WAThe capt stated that upon visual contact with the rwy, the acft was displaced slightly to the lt & he corrected toward centerline with rt rudder. Wing tip contact was neither heard not felt in the cockpit. There were several concurrent reports of arriving…NTSB MKC84FA058Accident · 1 fatalField investigationFinal reportCessna 152 · St. Charles, MOThe acft was progressing from a touch-and-go landing when it collided with transmission wires, 926 ft from the rwy at about 27 ft AGL. The weather was conducive to carburetor icing and the carburetor heat control was found partially open. Several gallons of…NTSB MIA84FA056Accident · 2 fatalField investigationFinal reportCessna T207A · Zolfo Springs, FLThe acft collided with trees and the ground during takeoff in IMC weather. The visibility was zero due to ground fog. There were no known witnesses to the accident but there was evidence of a collision with a 60 ft high tree at the end of the 3000 ft rwy. It…NTSB FTW84LA110Accident · No injuriesLimited investigationFinal reportCessna 182 · Mcallen, TXXb-cph, a foreign registered acft, was observed by the tower operator, to dive toward the rwy & pull up before starting to porpoise. The acft subsequently impacted the rwy striking the propeller & causing substantial airframe damage. Efforts to locate the plt…NTSB FTW84LA109Accident · No injuriesLimited investigationFinal reportCessna 150M · New Orleans, LADuring arrival, the acft lost power after a descent from 3000 to 2000 ft. at that time, the plt noted that the fuel gages indicated each tank was 1/8 full, but he did not apply carb heat until he was in an emergency descent. He elected to land on a boulevard.…NTSB CHI84LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Waverly, OHWhile landing on a 2000 ft rwy at Waverly, OH, the brakes were not effective, so the plt elected to go-around. During the go-around, the acft hit a fence at the end of the rwy. The plt continued flt to the ross county arpt & landed. An exam of the brakes…NTSB CHI84LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Holland, MIThe acft contacted a snowbank during landing. After the collision the acft nosed over. The plt stated that the winds forced the acft off the centerline of the rwy into the unplowed area of snow.NTSB CHI84LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIThe plt landed left of the rwy centerline with the acft 5 degrees left of the rwy heading. He did not correct to the right and the acft collided with a snowbank and nosed over.NTSB ATL84LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Charlottesville, VAThe plt reported that he started to lose control during the landing and added power to go-around. He said he pulled backon the controls and inadvertantly raised the flaps after he was already losing altitude. After touchdown, the acft flipped over.NTSB ANC84LA029Accident · No injuriesLimited investigationFinal reportCessna 172RG · Big Lake, AKThe dual student and instructor were practicing emergency procedures. During the turn onto final approach the left main landing gear and left wing struck a snowbank. Flying club procedures state that no emergency practice procedure will be conducted below 500…NTSB SEA84LA035Accident · No injuriesLimited investigationFinal reportHughes 269C · Almo, IDThe plt stated, he was attempting to depart with visibility of 1/8 to 1/4 mi in fog. Shortly after departure the visibility dropped to approximately 50 to 100 ft. he attempted a slow runing landing and landed hard.NTSB SEA84FA036Accident · 3 fatalField investigationFinal reportCessna C172N · Arco, IDAccording to company personnel, the flt was operated as a charter. The plt, also the company director of operations, was not authorized to conduct FAR 135 flights under instrument flight conditions. He was reported to have stated that he was going to 'get a…NTSB NYC84LA067Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Monson, MEOn a crosscountry VFR flight the pilot inadvertently encountered instrument conditions. During a climb to clear surrounding mountains the acft struck trees and crashed. The pilot had been briefed on the deteriorating weather prior to the flight. The pilot and…NTSB FTW84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Del Rio, TXDuring landing on a 4000 ft sod ranch strip the plt ran off the rwy into a raving and collapsed the landing gear. The plt said he landed in a crab and ran off the rwy. The owner on form 6120.1 stated that it was plt error, that the plt missed the rwy and ran…NTSB DEN84LA067Accident · No injuriesLimited investigationFinal reportCessna 210 · Grand Junction, COThe plt stated he touched down too hard, bounced & that he over-corrected causing the acft to land hard again collapsingthe nose gear.