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 NYC87LA161Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Speculator, NYThe plt had been practicing short water takeoffs with full flaps. After svcg the acft with a full load of fuel, he began a takeoff with 20 deg of flaps & got the float plane on the step. He rprtd that as he was applying full flaps, the acft enctrd a gust of…NTSB NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…NTSB MIA87LA173Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Vaiden, MSThe plt stated that during the takeoff ground run the acft travelled over a small rise on the rwy & became airborne prematurely. The acft then collided with trees while the plt was trying to maneuver it to avoid a populated area. The acft then collided with…NTSB MIA87LA172Accident · No injuriesLimited investigationFinal reportBushby Mustang II · Cocoa, FLDuring the landing roll the plt lost control of the acft. It then departed the rwy, collided with a taxiway marker sign & came to rest.NTSB LAX87LA227Accident · No injuriesLimited investigationFinal reportCessna 150L · Huelo, HIDuring a local pleasure sightseeing flight, the engine lost power and eventually quit. The plt initiated an emergency landing in a pineapple field where the acft collided with the terrain and nosed over. The acft was found to have aprx half a gallon of fuel…NTSB LAX87LA226Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Santa Barbara, CADuring an instrument landing system approach which is positioned partially over the water, the engine quit just after passing the faf. The pilot was unable to land the aircraft at the airport, instead, the aircraft was ditched in the ocean aprx 4 miles west…NTSB LAX87IA230Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAOver the outer marker, the captain extended the flaps to 50 degrees. As the flaps extended past 35 degrees, the airplane rolled to the left. The flaps were retracted to the 35 degree position and a go-around was executed. The flaps were set at 22 degrees and…NTSB FTW87LA140Accident · Minor injuriesLimited investigationFinal reportCessna 150G · College Station, TXThe pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground…NTSB FTW87FA137Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Bulverde, TXThe plt attempted liftoff two or three times but after each try the acft would settle back onto the rwy. When about 50 yards from the end of the rwy, the acft again lifted off the ground and climbed to about 15 ft. the plt stated that the stall warning…NTSB FTW87FA134Accident · No injuriesField investigationFinal reportRockwell Commander 112 · Ft.Worth, TXOn 6/6/87 a Rockwell commander 112, N1153J, impacted the terrain near meacham field, forth worth, Texas while on a photography flight. The pilot had been cleared to land on runway 16L when the tower changed the runway assignment to 16R. The pilot added power…NTSB DEN87FA147Accident · 4 fatalField investigationFinal reportBell 206L-1 · Choteau, MTThe EMS helicopter was returning to great falls, MT, on 6/5/87 when it crashed. Its occupants had earlier participated in a rescue seminar at many glacier, MT. The wreckage was not found until 6/9/87. A video tape recovered from the wreckage disclosed the…NTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…NTSB CHI87DEM07Accident · Minor injuriesFinal reportLake LA 4-200 · Fife Lake, MIThe plt stated that the engine started to run rough while in cruise flt. After all efforts to smooth it out failed, the plt elected to make a precautionary landing on Fife Lake. The acft landed normally followed by a loud noise and water started to enter the…NTSB BFO87LA041Accident · 1 fatalLimited investigationFinal reportPiccard AX-6 · Gaithersburg, MDAfter two aborted landings the pilot saw a field in the distance and attempted to land. Although two other balloons had landed nearby, the field he was blown towards had numerous powerlines surrounding it, some of them at treetop height. During the approach…NTSB ATL87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCEngine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on…NTSB ATL87LA158Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Kannapolis, NCThe Balloon pilot was executing a landing approach to a clear area. He failed to see and avoid electrical power lines on the near side of the field as he made his approach. The Balloon collided with the power lines and the basket landed hard. The Balloon…NTSB NYC87LA164Accident · Minor injuriesLimited investigationFinal reportBell 206L · Port Washington, NYThe plt of a Bell 206L made a downwind tkof with the acft loaded more than 100 lbs over the maximum allowable gross tkof weight. At an altitude of approx 100 ft, while complying with noise abatement tkof procedures, the plt experienced decreasing main rotor…NTSB NYC87LA158Accident · No injuriesLimited investigationFinal reportBeech 58TC · Oxford, CTThe flight was making an ILS approach to runway 36 in IMC. The aircraft touched down about 2,000 feet down the 5,000 foot runway and to the left of the runway centerline. The aircraft hydroplaned on standing water on the runway and skidded off the end coming…NTSB MKC87LA119Accident · Serious injuriesLimited investigationFinal reportBeech B35 · Keokuk, IAThe PIC rptd a loss of manifold press during cruise flt and an inability to maintain alt. A forced lndg was made to the Keokuk arpt, but the PIC stated he was too high and fast for a lndg. The PIC made a go-around, but again approached too fast. Another…NTSB MKC87LA118Accident · No injuriesLimited investigationFinal reportCessna 188C · Dalton, NEThe PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.NTSB FTW87DRD05Accident · No injuriesFinal reportGrumman G-164 · Kaplan, LAThe plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.…NTSB CHI87LA138Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Inver Grove Hts, MNAfter a loss of power, aircraft stalled. Although power was regained, aircraft crashed approx. 10 feet east of a grass strip adjacent to the seaplane base. Inspection revealed no mechanical malfunction or engine problem.NTSB ATL87FA161Accident · No injuriesField investigationFinal reportCessna 208B · Atlanta, GAThe two acft collided on a ramp while each was taxiing to rwy 8L for t/o. both acft were authorized by ATC to taxi to the rwy; the Cessna was instructed by ATC to follow the Beech. The two acft were hdg in the same general direction on converging paths when…NTSB NYC87FA170Accident · 2 fatalField investigationFinal reportCessna 310Q · Montgomery, NYN5527K crashed about 2 miles south of the orange cnty airport shortly after a night tkof fm runway 21. Departure instructions for the IFR flt included a right turn of 130 degrees, to 340 degrees magnetic to intercept V-58 and climb to 5000 ft. the plt…NTSB LAX87FA225Accident · 1 fatalField investigationFinal reportDouglas A-4A · California City, CAThe airplane, a civilian Douglas A4A, was engaged in filming a commercial which required the plt to fly over a ferrari vehicle. The pilot had completed a low filming pass over the vehicle and was circling the area while the film crew was preparing for another…NTSB LAX87DUG04Accident · Minor injuriesFinal reportGaston/Lakes Baby Lakes · Corona Airport, CAThe aircraft engine power reduced during the initial climb phase of the takeoff. The pilot attempted to return to the runway of departure. The aircraft landed hard on the airport and nosed over on its back.NTSB DEN87LA144Accident · No injuriesLimited investigationFinal reportCessna 188B · Malta, MTAfter takeoff on initial climb the acft had a pwr loss which resulted in a forced landing. A hard landing occurred in an open field which sheared off the main landing gear and damaged the airframe. The cause of the pwr loss could not be determined.NTSB CHI87LA142Accident · No injuriesLimited investigationFinal reportSchleicher KA-6-CR · Staunton, ILThe plt stated that he climbed to 6000 feet MSL and proceeded on course to Staunton, Illinois. According to the plt in a telephone interview, he was approximately 800-900 feet above willhoit airport when he made a 360 degree turn to enter base. He further…NTSB CHI87DEP06Accident · 1 fatalFinal reportZank Challenger II · Redgranite, WIThe student pilot had purchased this amateur built aircraft earlier in the day and had made one successful flight and was on the downwind leg of the second flight. The aircraft was at an estimated altitude of 150' to 200' AGL, when witnesses stated that the…NTSB SEA87LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Vancouver, WADuring a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during…NTSB SEA87LA108Accident · No injuriesLimited investigationFinal reportCessna T210L · Dayton, WADuring landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.…NTSB NYC87LA166Accident · No injuriesLimited investigationFinal reportNorth American B-25N · Stow, MAThe acft touched down hard on the grassy area 5 to 10 ft short of the rwy. The plt stated at the time that he felt and heard the hydraulic line burst in the cabin which left the aircraft without brakes. The acft failed to stop and continued to roll off the…NTSB NYC87FA160Accident · 2 fatalField investigationFinal reportRobinson R22 Mariner · So. Windsor, CTA loss of control in flight for undetermined reasons.NTSB MKC87LA116Accident · No injuriesLimited investigationFinal reportCessna 188-B · Sigourney, IADuring an unloaded re-positioning flt to begin an aerial application operation, the PIC experienced a total engine failure. A forced ldg was attempted and acft hit a ditch and was substantially damaged.NTSB MIA87LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Miami, FLDuring the landing roll the lt main landing gear collapsed. The acft then slid to a stop. Insp of the lt landing gear revealed that the upper & lower torque links which maintains parallel alignment of the tire to the fuselage separated. This occurred as a…NTSB MIA87IA170Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Jacksonville, FLDuring the landing roll the rt main landing gear collapsed. Examination of the landing gear revealed that the strut housing (trunnion) failed due to overload which was precipitated by fatigue and caused by a stress riser located on a manufacturing seam.NTSB LAX87LA223Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oxnard, CAThe pilot departed Oxnard arpt on a VFR flt to whitemant arpt, los angeles, CA. Grnd witness obsvd the airplane enter clouds and fog after crossing the western edge of the arpt boundary. The airplane was then obsvd in a descending left turn south of the arpt.…NTSB FTW87MA133Accident · 1 fatalMajor investigationFinal reportCessna P210R · Arnett, OKThe flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…NTSB DEN87LA142Accident · No injuriesLimited investigationFinal reportBell 206B II · Logan, UTThe plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an…NTSB CHI87LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marion, INAs the student plt was making a x-wind takeoff on a dual instructional flt, the instructor (CFI) reduced the power at about 15 ft AGL to simulate an eng failure. The student reacted by raising the nose of the acft, but the instructor corrected this by…NTSB CHI87FA139Accident · 2 fatalField investigationFinal reportBell 47G · Dayton, MNAircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…NTSB ATL87LA157Accident · No injuriesLimited investigationFinal reportBeech A36 · Greenville, SCThe plt made a precautionary ldg after experiencing acft electrical problems and observing the ammeter indicate discharging. The nose and rt main ldg gear collapsed during rollout braking. The plt reported that the gear had extended prior to ldg using the…NTSB MKC87LA115Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Lepanto, ARThe PIC had taken off for a LCL aerial operation. Enroute PIC had an engine failure and made a forced ldg in a muddy field. PIC applied brakes and acft nosed over. The exhaust rocker arm box on no. 3 cylinder was found to be cracked keeping exhaust valve in…NTSB LAX87LA222Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Payson, AZA Bell 47G-3B-1 collided with trees and was subsequently destroyed by fire after a loss of power in a remote wilderness area. The pilot reported the engine went to idle during flight. He was unable to regain engine RPM by manipulation of the throttle. The…NTSB DEN87IA145Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Casper, WYBoeing 727 (northwest flt 354) & USAF EC-135 (slum 51) were involved in a nr collision at FL 330. The mishap occurred asflt 354 was ene bnd on J-158 & slum 51 was flying on a radial-distance (r/d) flt pln, flying btn r/d pts south of J-158.as slum 51 apchd…NTSB ATL87LA156Accident · No injuriesLimited investigationFinal reportCessna C-152 · Bunn, NCThe airplane nosed over during a precautionary ldg in a soft, dirt field. The plt and a mechanic had been ferrying the airplane back to its base after replacing the starter and battery solenoids, and the battery. The pre-flt run-up had revealed no problems…NTSB SEA87LA107Accident · No injuriesLimited investigationFinal reportAerodynamics . Hawk Mkii · Ellensburg, WADespite warnings from the flight service station about turbulence, high winds aloft, severe low level wind shear, and low ceilings along the pilots intended route of flight, the pilot elected to depart the airport for his destination. Standing lenticular…NTSB MKC87LA114Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Knoble, ARThe PIC had taken off for a local aerial application operation. While maneuvering to make initial application the acft started to lose power and sink during a downwind turn. PIC dumped his load but acft continued to sink until one wing struck the terrain and…NTSB LAX87FA219Accident · Serious injuriesField investigationFinal reportBoeing 727-264 · Los Angeles, CAThe aircraft landed on rwy 25 left and was holding short of 25 right for a crossing clearance when the flight engineer started the APU. Passengers seated in the area between rows 20 and 22 on the right side of the cabin observed a 'bright' yellow blossoming…NTSB DEN87LA140Accident · Minor injuriesLimited investigationFinal reportCessna TU206D · Garrison, NDThe plt and a photographer were photo-mapping at 3,000 feet MSL. The plt reported that the engine quit at cruise. The plt selected a gravel road for the forced landing. The aircraft landed short of the intended touchdown pointin a plowed field and on…