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 MIA84IA140Incident · No injuriesIncident investigationFinal reportBoeing 747-121 · MartiniqueWhile climbing through FL200 crew experienced a loss of #4 hydraulic system pressure, illumination of the red 'gear door' and 'left wing door open' lights, a medium freq vibration and heard a loud rushing sound. Flt diverted to miami, FL, where landing was…NTSB MIA84FA139Accident · 2 fatalField investigationFinal reportRockwell 114A · Key West, FLThe acft took off from rwy 27. Several witnesses stated the acft appeared unusually slow during the initial climb. The plt reported to the tower he had a problem & was going to 'come around.' The acft entered a right turn and appeared to stop climbing at 200…NTSB LAX84FA255Accident · 1 fatalField investigationFinal reportFolke Wulf 1903A · Livermore, CAThe acft crashed after stalling during the initial climb after takeoff. The plt had called on the radio to say he was 'going to come back around.' When asked by the tower if he wwas declaring an emergency he did not answer. The acft reportedly was making a…NTSB FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.NTSB DEN84FU003Accident · Serious injuriesFinal reportAmerican Falcon · Salt Lake City, UTReportedly, the plt made an apch to rwy 18, then initiated a go-around due to traffic on the rwy. He reported that traffic to the left necessitated a right pattern. There were power lines located aprx 500 ft west of the grass strip, about 40 to 50 ft AGL.…NTSB ATL84LA144Accident · 1 fatalLimited investigationFinal reportBrown, R. M. JR. Monnett Moni · Kill Devil Hill, NCThe acft was the 4th acft to take off of 7 scheduled to make a formation fly-by of the wright brothers national memorial. As the acft took off to join up for the flt, a thick low fog bank rolled in. The other acft departed the area, but the plt attempted to…NTSB ANC84FA056Accident · Minor injuriesField investigationFinal reportPiper PA-20 · Anchorage, AKThe acft veered during takeoff roll and left the right side of the rwy after about 200 ft of roll. The left main landinggear collapsed and separated from the acft.NTSB MKC84LA123Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARThe owner/plt reported that just after lift-off, he heard a loud squeal & the eng lost power. He dumped his load to clear trees then landed hard in a wheat field just beyond the trees. A dissassembly of the eng revealed that a supercharger bearing had failed…NTSB MIA84LA135Accident · No injuriesLimited investigationFinal reportCessna 172P · Deland, FLAs a student plt in a Cessna 172P, N92ER, was taxiing to takeoff on a supervised solo flt, another student in a Cessna 172P, N78ER, was taxiing from landing. While passing, in opposite directions on a taxiway, the wing tips of the acft collided & both acft…NTSB LAX84LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Scaggs Island, CADuring a local flt, the acft crashed on the side of a levee while maneuvering. Both plts were seriously injured & neither of them could recall details of the flt. An exam of the crash site revealed the plane was traveling nearly parallel with the levee when…NTSB LAX84FA253Accident · 1 fatalField investigationFinal reportSturges BD-5B · Mckinleyville, CAAfter the acft took off, witnesses observed it enter a left turn, pitch nose up, then enter a rolling/vertical descent & impact at the edge of a surf. An exam of the wreckage & eng revealed no evidence of a preimpact/part failure or malfunction. A test plt…NTSB DEN84LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Monticello, UTThe pilot departed uphill with a tailwind at near gross weight with a high density altitude. The flight was late gettingstarted & an excessive magneto drop was attributed to a fouled plug. The pilot also stated that he was under mental stress. The acft lifted…NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.NTSB NYC84FGM03Accident · Minor injuriesFinal reportBliss Corbin Baby ACE CM-1 · Emporium, PAOn final approach the acft struck several trees, the pilot lost control of the acft. The acft then struck telephone wires & a pole and crashed.NTSB MKC84LA122Accident · Minor injuriesLimited investigationFinal reportBeech BE23 · Little Rock, ARThe acft crashed into trees during a forced landing. Examination of the acft fuel system after the accident showed less than 1 gallon of fuel in the right tank and about 15 gallons in the left tank. The acft was operated the entire flton the right tank and…NTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.NTSB MIA84FU004Accident · Serious injuriesFinal reportUnknown Easy Riser · Snead, FLThe ultralight collided with a high tension wire and crashed. The plt said he made a low pass to look at an auto and didnot see the wire in time to avoid the collision.NTSB SEA84LA086Accident · No injuriesLimited investigationFinal reportCessna 182Q · Neah Bay, WAThe plt landed long on the 1200 ft rwy and after overruning the end the acft collided with a ditch. The Washington state pilot's guide denotes the airport as 'closed-for emergency use only', and 'watch for livestock'. According to witnesses there were horses…NTSB MIA84LA133Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tallahassee, FLThe acft experienced complete loss of eng power while making an ILS app to rwy 36. A forced land was made into the treesfive mi south of the airport. Post crash investigation revealed no fuel in either fuel tank or any of he fuel drains. A subsequent eng test…NTSB FTW84LA200Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · New Orleans, LAShortly after touchdown on a x-wind landing, the tailwheel equipped acft began to weathervaned to the left into the wind. The plt lost directional control & the acft ground looped to the left. The right gear collapsed & the right wing dragged on the ground.…NTSB FTW84LA195Accident · No injuriesLimited investigationFinal reportCessna 150 · Papalote, TXThe acft collided with a powerline while making a low pass over a local residence during a solo training flt. The plts recommendation for prevention is to 'use common sense.'NTSB FTW84LA194Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Beaumont, TXThe acft stalled during a turn around between swath runs. The pilot stated that he was unable to recover because there was not sufficient alt.NTSB CHI84LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hoffman Estates, ILThe acft nosed over in a plowed field after the plt made an off-arpt landing. The plt said he was practicing turns around a point when he noticed a loss of alt and a sputtering of the engine. Since he was low he decided to land. (Therewas a sod strip 1/2 mile…NTSB ANC84LA055Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Bettles, AKThe acft groundlooped during landing. The plt said he lost control of the acft. During the swerve one of the gear legs failed and the acft skidded on the fuselage.NTSB NYC84FA137Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Marlboro, NJPilot and pax departing 2170 ft rwy at near max gross weight pax stated it didnt appear as if they were going to clear high tension power lines located about 2400 ft from rwy end. Pilot made left turn and impacted unmarked wires about 600 ft left of extended…NTSB LAX84LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Mathews, CAThe acft was making a go-around from about 100 AGL and collided with rising terrain. According to the plt the engine failed to respond properly. According to the passenger the engine response was normal. The investigation revealed that the acft was overweight…NTSB CHI84LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe student pilot, with an instructor pilot, were practicing touch & go landings. On the approach, the student allowed the speed to decrease, the acft stalled and landed hard and bounced back in the air. The student pilot added power to go around but did not…NTSB ANC84LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKThe acft was landed in winds reported as 35 to 42 KTS. According to the plt control was lost during the landing roll andthe acft ground looped to the right. The plt stated that there were no mechanical irregularities with the acft.NTSB NYC84LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Leonardtown, MDThe acft made a forced landing about 1 mile sw of an added stopping point. The plt noted a lower than planned gs and thought he should add a stop for fuel. During the flt he had encountered icing and because of climbs and descents to avoid wx for about an…NTSB LAX84LA249Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Fort Bidwell, CAAccording to the plt the wx blocked several of the mountain passes along the route of flight. When the wx continued to deteriorate the plt landed in a field. The main gear 'dug-in and the acft flipped on it's back.'NTSB LAX84FA251Accident · 4 fatalField investigationFinal reportGrumman AA-5A · Kamuela, HIThe acft with 4 occupants on board was being used on a sight-seeing flt to mauna loa volcano. The plt was in radio contact with hilo tower from 1503 to 1506 HST. He indicated concern about the clouds & decided not to proceed to the volcano. When the acft…NTSB FTW84FA193Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Houston, TXWitnesses heard the sound of an acft with the eng at high RPM. Shortly after that, they saw the acft in a left spin with the eng remaining at full power. The acft continued spinning until it crashed & burned. The witnesses noticed that when the plane was…NTSB ANC84FA052Accident · Minor injuriesField investigationFinal reportBellanca 7GCBC · Anchorage, AKThe student plt reported that when he was on final apch to land, the acft encountered turbulence at about 40 ft AGL, then bounced on the rwy. He applied power to go around, but lost directional control. The acft yawed left, veered off the rwy, knocked over a…NTSB SEA84LA080Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-26C · Mount Vernon, WAThe sailplane encountered deteridrating thermals & elected to make an off airport landing as he did not think he could reach the airport. He overshot the selected field in his attempt to miss some wires at the apch end of the field despitethe use of spoilers…NTSB MIA84LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Ormond Beach, FLDuring a hard landing, the prop, nose gear, eng mounts & firewall were damaged. The winds were gusting to 21 KTS.NTSB LAX84LA246Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 6B · Prescott Valley, AZWhen the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers…NTSB CHI84LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lafayette, INThe pilot was practicing accuracy landings when he noticed that the acft had blown away from the rwy. When he attempted to increase the throttle setting there was no response. In an attempt to land on a highway on-ramp the acft struck an electric wire, a…NTSB CHI84LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Leesburg, OHThe plt decided to land in a hay field to talk to the farmer about the aerial seeding operation he was conducting. During the landing the plt said the acft hit a soft spot in the field and nosed over.NTSB NYC84LA134Accident · No injuriesLimited investigationFinal reportHughes 269A · Danbury, CTWhile in flt, the helicopter yawed & the eng RPM increased. The plt retarded the throttle to idle, lowered the collective & initiate an autorotation. While attempting to reach a suitable landing area, the plt kept his speed up to avoid buildings. However,…NTSB NYC84FHM05Accident · 1 fatalFinal reportCessna 182P · Clarkstown, NYStudent plt stated he informed the CFI during takeoff that the acft would not continue to climb. The CFI then took control of the acft. Witnesses stated the eng seemed to stop and the acft entered a glide, banking to the left from aprx 150 ft AGL. The left…NTSB NYC84FA135Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, PAThe acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light…NTSB MKC84LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38 · St. Joseph, MOThe acft was landed in a gusty crosswind. The acft ballooned and landed hard which collapsed the nose gear.NTSB MKC84LA120Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Panama, NEShortly after takeoff, the eng lost power & decelerated to idle RPM. The plt attempted to restore power while making a 180 deg turn back to the arpt. During the landing, the acft struck the ground, nose 1st, collapsing the gear. The acft came to rest after…NTSB MKC84FA119Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Memphis, MOThe acft broke apart during a x-country flt. Some thunderstorm activity & turbulence existed along parts of the planned route of flt. However, there was no known adverse wx in the vicinity of the crash site. About 25 mi southwest at kirksville, MD, the 0745…NTSB MIA84LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Titusville, FLThe plt could not get the left main gear extended for landing and then could not get the right main and nose gear to retract for a'belly'landing. The acft was landed on the sod beside the rwy with the left main retracted. The nose gear collapsed during the…NTSB LAX84LA252Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Moorpark, CAThe plt reported that after completing the 2nd flt of the morning, he changed the fuel tank & acquired new passengers. He stated that during the 1st 2 flts, the Balloon had not drifted more than 100 yds from its point of lift-off. As the Balloon ascended on…NTSB LAX84LA245Accident · No injuriesLimited investigationFinal reportBeech E18S · Buellton, CAThese acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the…NTSB DEN84LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ogden, UTThe plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft.NTSB ATL84LA143Accident · No injuriesLimited investigationFinal reportAeronca O-58A · Rutherfordton, NCAfter the eng was started, the plt added power to taxi. He reported that the eng then went to full power & he was unable to stop the plane or control its direction thru the use of brakes & flt controls. The plane struck 3 other parked acft before the plt…NTSB ATL84LA142Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Hilton, SCThe acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing…