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 LAX84LA394Accident · Serious injuriesLimited investigationFinal reportExperimental Amateur Built OWL Racer · Oroville, CAThe Experimental/amateur built aircraft had just turned inbound for an exhibition race run when it experienced severe vibrations as the pilot applied full power. He headed for the runway and found that he could not control the engine with the throttle. He was…NTSB LAX84LA393Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Scottsdale, AZThe eng lost power after takeoff at about 150 ft AGL & the landing gear collapsed during the forced landing. The nose landing light rubber seal had separated & entered into the carburetor causing air blockage.NTSB LAX84FA395Accident · No injuriesField investigationFinal reportHiller UH-12E · Orcutt, CAMaintenance had just been performed & the crew were beginning a test flt to check the tracking of the main rotor blades. While the plt was hover taxiing, he lost collective control & rotor RPM decreased. However, he was able to make a roll-on landing, but the…NTSB FTW84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Charles, LAThe plt landed on the edge of a 90 ft wide turf rwy which was soft due to recent rains. The acft drifted off into a ditch causing the collapse of the left main gear.NTSB FTW84LA303Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Brookshire, TXThe acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop…NTSB DEN84LA224Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Richey, MTThe plt had finished spraying & was proceeding to the glendive arpt. He said that eng or prop began a sudden severe vibration which required the eng to be shut down. An emegency landing was made. The plt stated that the left wing impacted a hill which spun…NTSB DEN84FA222Accident · 2 fatalField investigationFinal reportNorth American P-51D · Carbondale, COThe plt was performing aerobatic maneuvers in a P-51D that had been modified for racing & exhibition. Witnesses near the accident site stated that the acft had just completed several aerobatic maneuvers before it began a vertical climb. The climb was…NTSB CHI84LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · North Liberty, INThe plt had changed departure runway due to shifting winds of 10-15 KTS, electing rwy 18 when wind seemed favorable. On initial climb, aircraft performance was insufficient to clear trees at end of runway. Acft came to rest in trees. Acft manual specifies…NTSB NYC84FNE03Accident · 1 fatalFinal reportPiper J4A · Gardner, MADuring climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…NTSB MIA84FA203Accident · Serious injuriesField investigationFinal reportLake LA-4-200 · Hollywood, FLAfter arriving at south Lake, the plt made a water landing on a westerly heading. He stated that he was attempting a step-landing & after touching down, the acft traveled about 100 ft, then the control yoke was jerked from his hands. He & the passengers…NTSB LAX84MA392Accident · 6 fatalMajor investigationFinal reportPiper PA-31T · Concord, CAThe Piper PA-31T was a foreign registered acft (federal republic of germany). The owner/plt in the left front seat held a german commercial certificate with airplane instrument, single eng land & multi-eng land ratings. The plt in the right front seat held an…NTSB LAX84LA391Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Vacaville, CAThe plt stated that he was high on final approach so he lowered the nose of the acft to lose altitude and in return got an increase in airspeed. He touched down 1/3 the way down the runway and the acft ballooned. He stated that he was unable to stop the acft…NTSB FTW84LA310Accident · No injuriesLimited investigationFinal reportCessna 182A · Marshall, TXThe acft was descended in a long glide from 5000 ft. the engine did not respond to throttle application on final. Pumping the throttle produced brief restarts. The plt landed in a rough field off the arpt. The nose gear separated and the acft nosed over. No…NTSB FTW84LA307Accident · No injuriesLimited investigationFinal reportCessna 152 · Eufaula, OKWhile taxing from landing the plt was watching the clearance on the left side of the acft and the right wing contacted an unmarked utility pole.NTSB CHI84LA300Accident · No injuriesLimited investigationFinal reportCessna 177 · Columbia, ILPilot stated that she landed the aircraft approximately one third of the way down the runway. She continued to stated the acft ballooned so she decided to go-around, during which she retracted the flaps to 1/4. The pilot operating handbook states that the…NTSB CHI84LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Almont, MIOn 7/13, the plt departed fraser, MI, with full fuel tanks & flew to lakes of the north. The next day he flew to mackinac island. He then departed mackinac island without refueling. Near flint, MI, the plt contacted apch control & informed them he was low on…NTSB CHI84LA295Accident · No injuriesLimited investigationFinal reportCessna 172M · Southgate, MIAfter takeoff, the plt climbed to 8500 ft MSL to practice maneuvers. He then made a descent to 4500 ft & began heading back to the arpt, then continued descending to 1800 ft & entered the tca. The eng lost power aprx 7 miles from the airport. Later, during an…NTSB ANC84LA115Accident · No injuriesLimited investigationFinal reportCessna U-206 · Naknek, AKThe acft nosed over during a landing on a sandy beach. Witnesses stated, according to the plt, that the nose wheel was cocked 45 degrees to the right while the acft was on the final approach. Upon touchdown the acft veered to the right, the nose gear…NTSB NYC84LA241Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe student plt landed in a corn field short of the rwy on his 3rd solo landing. The plt stated that he 'misjudged the end of the rwy.' He also said he should have had a 'higher approach speed.'NTSB MKC84LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe acft crashed into a levee in a rice field after losing engine power during a spray operation turn-around. The enginedid not quit entirely but lost enough power so that flt was not maintained. An inspection of the engine revealed a broked connecting rod.NTSB MKC84LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brule, NEAccording to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.NTSB MIA84LA202Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Springs, FLThe pilot stated that after recovering from a bounced landing, he started to lose directional control. He stated that he over compensated for the turn & added power to takeoff again. However, the acft veered left & subsequently nosed over.NTSB LAX84LA368Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Tucson, AZThe student pilot lost directional control during the landing roll. The instructor pilot was unable to regain control to prevent a ground loop. Subsequently, the acft veered off the rwy & was damaged on rough terrain.NTSB LAX84FA390Accident · Serious injuriesField investigationFinal reportCessna T188C · Brawley, CAThe acft crashed shortly after takeoff from a dirt strip. The plt said the acft was 'over-gross' and that it would not climb. The plt had used full flaps for takeoff and when the acft would not climb he reached for the dump or load jettison handle and grabbed…NTSB CHI84LA293Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Richmond Hts, OHThe aircraft was being flown back from an annual inspection. The pilot stated after the accident that he experienced a loss of power while on downwind leg for landing on rwy 23. The pilot attempted a landing on rwy 5 but the acft landed 1500 feet short.…NTSB CHI84FA292Accident · Serious injuriesField investigationFinal reportCessna 182A · Henryville, INThe aircraft's annual inspection was thirteen years overdue and the pilot had not logged any flight time inn almost one year. Twenty eight airworthiness directives had not been complied with. The engine quit shortly after take off, when the magneto coils…NTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…NTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…NTSB ATL84LU007Accident · Serious injuriesFinal reportTeraton TA · Snellville, GAAfter making a touch & go landing, the plt was unable to climb over trees at the departure end of the rwy. Subsequently, the ultralight vehicle lodged in a tree about 40 to 50 ft AGL. The plt said that he was not injured during the impact with the tree.…NTSB SEA84FA172Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus A · Ephrata, WAA 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of…NTSB SEA84FA171Accident · Serious injuriesField investigationFinal reportCessna A185F · Ketchikan, AKThe engine quit due to fuel starvation shortly after takeoff. The pilot had selected an empty tank. He then switched tanks but flooded the engine as a result of not following procedures in the aircraft manual. Unable to glide to an appropriate landing site,…NTSB NYC84LA288Accident · No injuriesLimited investigationFinal reportCessna 172PII · Madison, CTPlt stated groundspeed was fast during the flare and an abrupt touchdown was made 'fairly far' down the rwy. Plt reported, 'braking had not sufficiently slowed or stopped the plane as the plane neared the end of the runway, and it veered off to the right of…NTSB MKC84LA213Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARDuring swath run engine ran rough and could not sustain acft in flight. The plt made a forced landing in a soft freshly plowed field. The acft nosed over during the landing. Inspection of the acft revealed that one magneto was missing teethfrom the drive gear…NTSB LAX84FA389Accident · 4 fatalField investigationFinal reportCessna 180 · Randsburg, CAPlt attempted to land on a 1200 ft long airstrip. He landed the acft with a tailwind and touched down aprx 600 ft from the apch end of the rwy. The acft skidded off the right side of the rwy and collided with a caterpillar tractor. The four occupants were…NTSB FTW84LA309Accident · No injuriesLimited investigationFinal reportBeech C-45-H · Mcalester, OKAbout 40 miles from Mcalester arpt, the lt eng lost pwr & was shutdown. While attempting a precautionary ldg at the arptthe rt eng lost all pwr. While making an emergency descent the plt attempted to stretch the glide. The acft collided with trees 300 ft…NTSB DEN84LU008Accident · Serious injuriesFinal reportWeedhopper Unknown · Spanish Fork, UTThe ultralight was taking off from a street with obstructions on either side. The plt said that during the climbout, he encountered a x-wind from the north which blew him into a lamp post. The vehicle and pole were damaged and the vehicle crashed to the…NTSB DEN84LA220Accident · No injuriesLimited investigationFinal reportBeech F33A · Glen Canyon, UTAccording to the plt, a slightly higher than normal apch speed with partial flap extension was used for the apch due to the turbulance and wind gusts to 25 KTS. After crossing the threshold at 20 to 30 ft AGL the flare resulted in what the pilot described as…NTSB DEN84FA219Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Peetz, COPlt had completed spraying around farm buildings for insect control. On first pass in crop area, the acft was observed to pull up over pwr lines at end of swath run but collided with overhead ground wire at top of multi- wire array. Acft then collided with…NTSB CHI84LA291Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti FN-333 · Lansing, MIThe acft was not flown for 6 yrs. During last annual inspection, 67 hrs of labor, the batteries (2), spark plug gaskets,magneto gaskets, battery cable lugs and impulse coupling were replaced. The fuel quantity transmitter, battery, magnetos and spark plugs…NTSB SEA84FA170Accident · Minor injuriesField investigationFinal reportAero Commander 680T · Castle Rock, WAThe acft was on a x-country trip. On previous flts over the same route, 2 refueling stops were made. During this trip, no refueling was accomplished, & while en route, the low fuel warning light came on. The plt declared an emergency & wasvectored & assigned…NTSB MKC84LA232Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Farnam, NEWhile the plt was returning to the arpt from an aerial application mission, the eng lost power & he elected to land on a road. During the landing, the acft struck a bridge & was substantially damaged. Investigation did not reveal cause of power loss.NTSB MKC84LA212Accident · No injuriesLimited investigationFinal reportCessna 172 · Beuamont, KSThe plt was taking off to the north on a sod rwy with a light, northeast wind. The rwy was outlined with old automobile tires. The plt elected to use the left side of the rwy, since it appeared to be smoother. After lift-off, the acft drifted left & the left…NTSB MKC84LA209Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · West Memphis, ARThe acft nosed over during an off arpt forced landing following an engine failure. During post accident examination the acft was found to have a cracked #7 cylinder.NTSB LAX84FU029Accident · 1 fatalFinal reportUltralight Soaring Wizard J-3B · Lake Elsinore, CAThe Ultralight was observed by witnesses to be circling, then performed what was described as a 'barrel-type' maneuver. During the maneuver, the right wing collapsed and the acft spiraled to the ground in an uncontrolled descent. During theinvestigation of…NTSB FTW84LA308Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Henderson, TXThe instructor plt stated that the student plt landed the helicopter. As the helicopter touched down and was still light on its skids the student applied left cyclic control and the helicopter started to roll towards the left. The student plt froze on the…NTSB DEN84LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Dickinson, NDThe pilot stated that he received landing information for the Dickinson muni airport. He continued to state, 'set plane up for landing, checked plane over everything was set up, started to land, prop hit rwy, the next thing I was sliding down rwy.' The…NTSB CHI84LA288Accident · No injuriesLimited investigationFinal reportRotorway Executive · Cambridge, WIThe fixed wing plt who was not qualified to fly rotorcraft tried to hover his homebuilt acft. After failing the 1st timehe tried again and this time the acft rolled over and burned. The plt said the roll over occurred so fast he did not have time to act.NTSB ATL84LA220Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Lambert, MSDuring the landing roll the tailwheel reportedly oscillated braking the shock strut lugs allowing the tail of the acft to contact the sod runway. The plt applied hard braking and the acft nosed over. The plt reported nothing was wrong with the tailwheel…NTSB ATL84LA219Accident · No injuriesLimited investigationFinal reportHaxton Quickie Q2 · Kennesaw, GAThe home built acft had just been constructed & the plt was making hi speed taxi checks. On the 3rd check, he applied full power, intending to accelerate to a target speed of 60 mph. He reduced the power before reaching that speed; however, the acft…NTSB ANC84LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe acft ran off the right side of the rwy after touchdown. The plt indicated that the right main tire blew out. He saidthat he was unable to keep the acft on the rwy and it nosed down into soft dirt.