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 MKC84LA141Accident · No injuriesLimited investigationFinal reportCessna 120 · Larchwood, IAThe acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt…NTSB MKC84LA139Accident · No injuriesLimited investigationFinal reportCessna 152 · No.Little Rock, ARThe acft collided with a rwy light and nosed over during landing in a x-wind. The wind was reported to the student as from 040 degrees at 9 KTS at takeoff and 070 degrees at 11 KTS when she returned to land. These winds converted to a 90 degree x-wind of 6.5…NTSB CHI84IA197Incident · No injuriesIncident investigationFinal reportde Havilland DHC-7-102 · Battle Creek, MIWhile cruising at 7000 ft MSL, the 1st officer was trimming the rudder, using the rotary switch on the center console, when he felt a 'snap' inside the switch. After that, the switch would rotate freely between the stops. The acft began yawing left & right…NTSB CHI84FA194Accident · Minor injuriesField investigationFinal reportBeech A36 · Schaumburg, ILThe plt reported that he lost partial engine power during climb and decided to return to the arpt. He said the engine changed power output when he used the electric fuel pump but he left it off. During final approach, not having declared an emergency, he had…NTSB ANC84LA069Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe acft was established in normal cruise when the engine quit. The pilot attempted restarts with negative results. The acft made a forced landing and collided with trees. Post accident examination revealed water in the fuel tanks & lines.NTSB DEN84LA149Accident · No injuriesLimited investigationFinal reportCessna 172N · Kindred, NDThe pilot stated that he made a normal landing approach to runway 15. During touchdown a gust of wind hit the airplane. The pilot said he was caught off guard and before he could regain control, the airplane went off the right side of the runway, struck a…NTSB CHI84LA190Accident · No injuriesLimited investigationFinal reportBeech V35B · West Chicago, ILThe acft bounced during landing and lost the nose gear in the process. The plt stated he touched down on all three gear, ballooning back into the air nose high. He stated he pushed the nose down to gain airspeed when the nose hit the runway breaking off the…NTSB CHI84LA189Accident · No injuriesLimited investigationFinal reportCessna 190 · St. Anne, ILThe plt stated that during his 2nd takeoff from a restricted landing area, the eng hesitated at an alt of about 10 ft AGL. He then aborted the takeoff & tried to land on the remaining rwy. However, the acft touched down in a plowed field where it nosed over.…NTSB ATL84LA170Accident · 1 fatalLimited investigationFinal reportCessna 172N · Nashville, TNThe plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his…NTSB ANC84FA068Accident · Minor injuriesField investigationFinal reportCessna 182N · Fairbanks, AKDuring takeoff, the acft lifted off at about mid-field, then it touched down & became airborne again before it crashed. It came to rest in an inverted position, 1017 ft beyond the end of the rwy. No abnormalities of the eng were found other than impact…NTSB SEA84LA106Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carson City, NVAccording to the plt, the wind was from 230 deg at 12 gusting 18 KTS. He said that he had just lifted the tailwheel when a 'dust devil' push the acft to the right of the rwy. The acft then struck sage brush & a barbed wire fence & nosed over.NTSB NYC84LA172Accident · Serious injuriesLimited investigationFinal reportCessna 305A · West Hampton, NYThe acft had just landed & the plt was taxiing to hook up to another glider when the acft became lodged n soft dirt. Two ground crewmembers came over to the acft. The plt stated that he told one of them to 'stay behind the strut while I shutdown'. He then…NTSB MKC84LA137Accident · No injuriesLimited investigationFinal reportBeech BE95A55 · Springfield, MOThe acft landing gear collapsed during landing. The plt said he was following a metroliner & put the gear handle 'down' but does not remember the gear indicators. He reduced the throttles to about 11 inches of manifold pressure & does not remember hearing a…NTSB LAX84LA291Accident · No injuriesLimited investigationFinal reportTaylorcraft F21 · Payson, AZThe acft was landed 200 ft short of the rwy in bushes after the engine hesitated during the plts application of throttle in an attempt to reach the rwy. An FAA inspector found the magneto timing set to 23 plus degrees rather than the prescribed 20 degrees.NTSB LAX84FU027Accident · 2 fatalFinal reportMitchell TU-10 · Perris, CAThe purpose of the flt was for one instructor plt (CFI) to check out the other CFI in the ultralight vehicle. Reportedly, many witnesses watched as the acft climbed to aprx 3000 ft AGL. The aircrew then performed a series of rolls to the left & right. The…NTSB FTW84LA232Accident · No injuriesLimited investigationFinal reportCessna 170 · Victoria, TXThe pilot stated that while on a long final approach power was reduced for descent. Shortly thereafter the throttle was applied but the engine failed to respond. The aircraft landed 100 yards short of rwy 17. The pilot stated after the accident that he…NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB FTW84FA224Accident · Serious injuriesField investigationFinal reportAeronca 11BC · Hamilton, TXThe acft stalled at 1500-2000 ft AGL and collided with a fence and the ground during recovery attempts. The plt said theacft was intentionally stalled but the spin was not expected. The acft was estimated to be aprx 47 lbs over max gross weight. The flt had…NTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…NTSB CHI84LA191Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Columbus, OHThe acft right main gear failed during takeoff roll when it passed over an arresting cable. It was reported that the tailwheel was damaged on a previous landing at rickenbacker afb when it passed over an arresting cable and had since been replaced.…NTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…NTSB CHI84LA186Accident · No injuriesLimited investigationFinal reportHughes 500D · Rensselaer, INHard forced landing made after loss of pwr at cruise alt of 500 ft AGL. Main rotor blades contacted tail boom. Examination disclosed fuel pump gears showed signs of corrosion. Gear teeth and end faces were severly etched and pitted. Bronze particles were…NTSB ANC84FA067Accident · No injuriesField investigationFinal reportBell 206B · Palmer, AKThe helicopter was being used to re-supply fire fighters by the division of forestry. En route back to the staging area the acft struck unmarked lines 85 ft above the valley floor. Poles supporting the lines were obscured by vegetation and were 224 ft apart.…NTSB SEA84LA105Accident · No injuriesLimited investigationFinal reportHelio H-700-SP · Meridian, IDThe plt stated that while landing onto his own field the left main gear caught in a deep furrow. The acft then veered to the right striking a woven wire & barbed wire fence, & a railroad tie.NTSB NYC84LA174Accident · No injuriesLimited investigationFinal reportBeech Bonanza F33A · Tarentum, PAPlt made lndg apch to rwy 02 at 95 mph, flaps one-third down and rt wing down for wind compensation. Plt stated winds were at 090 deg. At 30 ft above the rwy the acft encountered a sudden gust of wind from 270 deg. The acft drifted to thert side of the rwy…NTSB NYC84LA169Accident · No injuriesLimited investigationFinal reportCessna C150 · So.Bethlehem, NYThe student pilot and instructor had just started the inital climb when the engine quit at about 100 ft. the application of carburator heat caused a few second burst of power then the engine stopped again. The CFI took the controls and turned left. He landed…NTSB NYC84LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Montrose, PAPilot attempted to land on a 2200 foot grass runway. The plt overshot the runway and attempted to go-around. The aircraft collided with trees at the end of the runway.NTSB NYC84FNC02Accident · Serious injuriesFinal reportPiper PA-31S 2 · Rockland, MEFollowing the rwy 03 LOC apch plt decided to land straight in with a tailwind rather than circling because of low clouds surrounding the arpt. Acft touched down with aprx 2000 ft of wet rwy remaining. Acft traveled off end of rwy until it contacted an…NTSB MKC84LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Lepanto, ARThe acft lost power during an aerial application flt & crashed during a forced landing. An investigation revealed that the magnetos were not in an airworthy condition at the time of the accident. The acft had been operated 338 hrs since the last 100 hr…NTSB LAX84LA307Accident · No injuriesLimited investigationFinal reportDe Havilland DHC 6-300 · Tau, Manu'A, HIAccording to the pilot, upon arrival in the vicinity of the arpt it was determined that the windsock indicated southeasterly winds at 15 to 20 KTS. This, plus light to moderate turbulence encountered in the traffic pattern led the crew to fly a slightly…NTSB LAX84LA295Accident · No injuriesLimited investigationFinal reportCessna A150K · Trona, CAThe acft settled back to the rwy and veered of the left side during takeoff. The plt stated that he attempt a short field takeoff and the acft would not accelerate to more than 60 mph. It settled onto the dirt off the left side of the rwy and groundlooped to…NTSB LAX84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phoenix, AZThe plt had just purchased the acft & had flown it only 3 hrs. The purpose of this flt was to ferry it to deer valley for a paint job. He reported that when he landed, the wind was from 150 deg at 6 gusting 12 KTS. During the landing, the nose wheel touched…NTSB LAX84LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague, CAAn improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &…NTSB FTW84LA231Accident · Minor injuriesLimited investigationFinal reportStarduster SA-300 · El Paso, TXWhile in the arpt traffic pattern for landing, the plt experienced an engine failure and landed short of the rwy. The acft collided with a sand dune. The plt stated that he had experienced a loss of fuel pressure on previous flts but had not corrected the…NTSB DEN84LA150Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Nucla, COPlt stated, 'I made one pass on low boundry spreading 100% of seed and began a climbing left turn to make a pass from high side down east boundry. I reached altitude of approximately 300 ft AGL (above ground level) and attempted to pass over telephone draw…NTSB DEN84LA147Accident · No injuriesLimited investigationFinal reportCessna TU206F · Strasburg, CODuring the takeoff phase of a touch-&-go, the eng quit about 100 ft AGL. The plt landed back on the rwy but the acft ran-off the end collapsing the nose gear. Evidence of water contamination was found throughout the fuel system. 1/2 of liquid drained from…NTSB DCA84IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 · Los Angeles, CADuring rotation the #2 eng sustained an explosive rupture of its compressor rear frame(crf). The crew observed a rapid drop in the #2 eng performance parameters & the illumination of the #2 eng thrust reversers 'unlock and in transit' lites. The crew…NTSB CHI84LA192Accident · No injuriesLimited investigationFinal reportBeech 23 · Put-In-Bay, OHDuring the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but…NTSB CHI84LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcarthur, OHThe plt stated that during final approach at about 5 ft above the ground the acft was struck by a gust of wind that lifted the acft about 20 to 30 ft up and to the left of the runway. He stated tha a downdraft placed the acft in a position where 'maximum…NTSB CHI84LA185Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Minneapolis, MNThe plt was in the process of buying the Cessna 172. He took off on a local flt and after doing some airwork, he returned to the arpt. On final apch to rwy 27L, the acft was observed at a low alt. It continued descending and collided with microwave landing…NTSB ANC84IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146 · Unalaska, AKA 'no brake condition' was experienced while the plt was using the yellow brake sys during a landing. The normal landing procedure calls for using the green sys. During the roll-out, the plt selected the emergency yellow sys & subsequently locked the brakes.…NTSB NYC84LA171Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Spencer, MAAccording to the plt, the purpose of the flt was to practice autorotations. During practice, the acft touched down hard & was substantially damaged.NTSB NYC84FA170Accident · 1 fatalField investigationFinal reportI.C.A. Brasov IS-29D2 · Collegeville, PAAccording to a witness who ran the wing of the glider during takeoff, at 250 to 300 ft AGL the tow acft turned left but the glider maintained rwy heading. Shortly thereafter the tow line released at the glider-end and the glider initiated a right turn. After…NTSB MIA84FA165Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4 · Fort Myers, FLThe eng was heard 'popping' & misfiring during the takeoff roll. About 1 min later while climbing thru 400-500 ft, the plt reported an eng failure & was cleared to land on any rwy. The acft entered a left turn, stalled & spun into a parking lot. An exam of…NTSB LAX84LA292Accident · No injuriesLimited investigationFinal reportCessna 182RG · Palo Alto, CAAcft touched down on the nose gear, porpoised and finally impacted the rwy on the nose gear.NTSB LAX84LA286Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Hayward, CAAccording to a plt/operator statement, the private plt (PIC) was on an instruction flt. The other occupant, was a person whose commercial plt certificate had been suspendended. The PIC reported that the helicopter had just received an annual inspection & had…NTSB FTW84LA226Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Cedar Hill, TXDuring the initial night flight after an oil change & annual inspection, the helicopter experienced a total power plant failure. An autorotation was performed & the helicopter struck a building prior to coming to rest. Inspection of the wreckage revealed…NTSB CHI84LA182Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Marion, ILThe acft crashed after takeoff from rwy 29 at williamson county airport. The plt stated that she mismanaged the fuel system & that she 'probably tookoff on fumes.' She further stated that she should have told the company 'I'm to tired to make this flt.'NTSB ATL84FA169Accident · 2 fatalField investigationFinal reportCessna 310R · Clarkson, KYThe acft crashed after an in-flt separation of various components of the airframe. Post accident evidence provided by the failed parts gave a graphic picture of the in-flt seq which was supplemented by a witness who saw & heard the acft in its final dive.…NTSB ANC84FA065Accident · No injuriesField investigationFinal reportCessna TP206D · Homer, AKThe eng quite once, but the plt was able to restart it by turning on the boost pump. He landed at 2 different arpts after the initial failure, once to refuel & drain the fuel tanks & once to check the fuel lines & components under the cowling. Aprx 1 hr after…