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 LAX84LA366Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Concord, CAAccording to a plt/operator statement, the student plt was cleared for a downwind apch to land on 'pad 3.' The student stated that the apch was normal until he slowed to 40 mph & 'made left turn to final approach into a cross wind.' During the turn to final…NTSB FTW84LA289Accident · No injuriesLimited investigationFinal reportCessna A188B · Speaks, TXDuring takeoff to the south the northerly wind picked up. Acceleration was not sufficient enough to become airborne before end of airstrip. Acft overran airstrip and collided with a ditch. Density alt was 2,500 ft MSL and acft loaded with 1,200 lbs of…NTSB FTW84LA285Accident · No injuriesLimited investigationFinal reportCessna T210N · Monahans, TXThe plt made several unsuccessfull downwind landing attempts. The last attempt was long & fast & upon go around, the acft struck the arpt boundry fence & came to rest 700 ft past the departure end of the rwy.NTSB FTW84FA287Accident · Minor injuriesField investigationFinal reportBell 212 · Galveston, TXDuring takeoff, the helicopter lifted off in an 80% power check & the plt began a northerly departure. Before achieving translational lift, the rotor RPM dropped to aprx 85%. The torque meter indicated a split with the #1 eng indicating about 55% & the #2 eng…NTSB DEN84LA215Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Marion, SDIn cruise flt, oil covered the windscreen and plt elected a precautionary landing on a dirt road. Acft collided with a mailbox on roll out and nosed over. Oil filler cap found loose.NTSB DEN84LA197Accident · No injuriesLimited investigationFinal reportCessna T188C · Philip, SDThe plt lost control of the acft during takeoff ground run when his vision was obscured by water which was sprayed on the windshield from a light rain shower.NTSB DEN84FA194Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Cedar City, UTThe acft collided with rising terrain in a box canyon. The plt said he found himself trapped with the terrain coming up 'to meet the plane' and decided to try and land on a nearby road. The acft stalled into trees prior to reaching the road. The plt also said…NTSB CHI84LA265Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kankakee, ILThe eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.NTSB ATL84LA209Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Williamsport, TNPilot stated that while departing from a small 2000 foot long private strip the engine appeared to loose power. The aircraft would not climb and collided with a tree at the departure ens of the rwy. The acft then collided with several other trees prior to…NTSB ANC84LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Flathorn Lake, AKAccording to the passengers,the plt was flying at aprx 250 ft when they saw a bear. After starting a left turn, the nose of the acft dropped. One passenger said the plt made a tight turn before the plane lost its lift. The other passenger stated that the acft…NTSB ANC84IA101Incident · No injuriesIncident investigationFinal reportCessna 207A · Larsen Bay, AKAbout 12 mins after takeoff while at 2300 ft MSL, the eng began to shake, oil covered the windshield & oil pressure was lost. Subsequently, the plt made a forced landing in an area of tall grass on a river delta. During the landing, the nose gear collapsed &…NTSB SEA84LA144Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes AX-8 · Monroe, WADuring the ballon descent, the plt said he briefed the passengers to bend their knees & hold onto something inside the basket. According to the plt , the descent became more rapid due to a downdraft. The passengers were again warned to 'hang on' because it…NTSB SEA84LA143Accident · No injuriesLimited investigationFinal reportEipper Quicksilver Mark II · Salem, ORPlt attempted takeoff on short grass field at gross wt with a OAT of aprx 80 deg f. once airborne the acft drifted to the left of the airstrip. Plt pulled up to clear a fence. After clearing the fence the acft stalled striking the ground with the left wing…NTSB MKC84LA183Accident · No injuriesLimited investigationFinal reportCessna 150H · Nebraska City, NEUnable to start the engine with the electrical starter the pilot elected to pull the propeller through by hand. With the magneto switch 'off' and a 2X6 inch board in front of one main landing gear tire the engine started when the propeller was rotated. The…NTSB MKC84LA182Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Overland Park, KSPrior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…NTSB LAX84LA369Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126D · Lucerne Valley, CAThe student plt reported that during a winch launch with a left x-wind, the wind lifted the left wing & the right wing contacted the ground. The glider then veered to the right & the right wing hit a wind sock & a vehicle. He reported that a wind-shift had…NTSB LAX84LA364Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lee Vining, CAThe plt reported that after entering tioga pass, he made a left turn to follow the center of the pass & the acft began to sink. He applied full power & went to the best angle of climb speed, but was unable to stop the sink. The acft then hit an electrical…NTSB DEN84LA193Accident · No injuriesLimited investigationFinal reportCessna 188B · Albuquerque, NMThe arpt had a UNICOM & 2 rwys, 17/35 & 10/28. The acft had an operable radio, but the plt did not call UNICOM. He elected to land on rwy 17 which had a x-wind from 100 degs at 20 KTS. During the apch, the plt compensated for the x-wind by lowering the left…NTSB DCA84IA029Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Chicago, ILAbout 26 min before landing crew received SIGMET 1C advising of line of thunderstorms from milwaukee to st. louis movingse at 15 KTS. They also became aware of a thunderstorm west of arpt. At about 20 mi NE of arpt they could see the storm visually & on radar…NTSB CHI84LA268Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Batavia, ILThe plt received a wx briefing before the flt. The 1950 surface observation reported winds from 090 deg at 4 KTS. During flt, the winds suddenly picked up & the plt attempted a landing. A rapid rate of descent developed & the balloon collided with trees…NTSB CHI84LA260Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Geneva, ILThe Balloon descended in an area of thunderstorms and turbulence and collided with trees. The plt said the Balloon 'caved in' and descended rapidly. The plts husband and a passenger revealed that the Balloon was 'vented' by the plt to land before reaching a…NTSB CHI84LA259Accident · No injuriesLimited investigationFinal reportBeech S35 · Ottawa, ILThe plt said he 'left word' for the Ottawa arpt lights to be left on until 0200 hrs on 6/24. When the flt arrived at Ottawa, the lights were not on. The plt said he 'attempted to make an approach, it failed.' The acft was landed in a nearby field. The arpt…NTSB CHI84LA258Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Mears, MIThe pilot reported that when the amphibious aircraft reached 8 to 10 feet AGL during takeoff, a x-wind gust caused the left sponson to contact the water surface. This caused loss of control and resulted in the plane crashing inverted in the Lake.NTSB CHI84LA257Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Lewisburg, OHAfter descent from 4000 ft to 1000, plt applied pwr for level off & eng did not respond. Carb heat was not used during descent or after power loss. Plt executed forced landing in bean field, colliding with a wire on approach and damaging the right main gear.…NTSB ATL84MA208Accident · 5 fatalMajor investigationFinal reportPiper PA-32-300 · Canton, GAThe acft with a student plt at the controls had an in-flt breakup during a night x-country flt. During a preflt wx briefing, he was advised that VFR flt was not recommended. The plt terminated the conversation before the briefing was completed. While in flt,…NTSB ATL84LA211Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · Gilbertsville, KYThe acft was used for public rides at an amusement park. During the takeoff to ferry the acft back to an overnight parking space the engine quit at 100 ft AGL. The plt said he started the acft and hovered using fuel from the aft fuel tank. When the engine…NTSB ANC84LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Bear Creek, AKThe acft crashed into a river bank during an attempted go-around. The plt reported that upon initial touchdown the acft bounced and he applied full throttle. The engine reportedly responded with a maximum RPM of about 1600. The acft bouncedagain on the…NTSB ANC84LA099Accident · No injuriesLimited investigationFinal reportInterstate S-1B2 · Anchorage, AKThe plt reported that he began taking off on rwy 31 with an 8 kt x-wind, but after he started rolling, he noticed the wind had changed to 'downwind.' The plane 'seemed to pull hard to the left' & he could not maintan rwy alignment. As the acft apchd the left…NTSB SEA84LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fall City, WAThe plt was approaching a strange arpt with a rwy elevation of 140 ft and surrounding terrain of 1000 to 3000 ft. the plt said as he approached the threshold he felt the acft was too high so he executed a go-around. With the flaps at 20 degrees he said his…NTSB SEA84LA141Accident · No injuriesLimited investigationFinal reportCessna 207 · Anacortes, WAThe plt stated he added 10 degrees of flaps on downwind and applied full flaps on final. A rapid rate of descent was experienced 200 yards from touchdown. The pilot said he added power to arrest the sink rate. The acft collided with trees on final. The pilot…NTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…NTSB NYC84LA219Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Amityville, NYThe acft sustained substantial damage during a step turn maneuver on the water. The student was briefed by the instructor prior to the flight and they proceeded to perform training maneuvers over the water. During the step turn maneuver, the instructor…NTSB NYC84FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Keymar, MDWitness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…NTSB MKC84LA181Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Campbell, MOPIC was making a clean up swath run after spraying a field and failed to avoid a high voltage power line. After strikingthe line the acft impacted the ground, caught fire and burned.NTSB MIA84FU006Accident · 1 fatalFinal reportStorey SKY PUP · Indiantown, FLThe ultralight experienced an in-flight separation of the left wing. The wing separated at the wing attachment fitting. The plt & ultralight had a parachute attached but it did not deploy.NTSB LAX84LA365Accident · No injuriesLimited investigationFinal reportStinson 108 · Camarillo, CAA prospective buyer in the left seat was initiating a takeoff in a tail wheel acft when the acft ground looped and the right main landing gear collapsed. The owner in the right seat was unable to correct the situation in time. The buyer had professed…NTSB LAX84LA363Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Corona, CAThe eng quit & a forced landing was made in an open field. During the flare for touchdown, the eng restarted and the the landing roll was increased. The plt was unable to stop the acft before colliding with a concrete abutment. Less than 2 gal of fuel was…NTSB FTW84LA292Accident · No injuriesLimited investigationFinal reportCessna 152 · Giddings, TXThe student plt on his first solo cross-country flight became lost. The plt landed to refuel but the facility was closed. He departed to refuel elsewhere and ran one fuel tank dry enroute. Upon reaching the second arpt, the plt performed a landing on rwy 35…NTSB FTW84LA284Accident · No injuriesLimited investigationFinal reportGriffin Trane Starduster TOO · Oklahoma City, OKAcft touched down hard after 4 unsuccessful landing attempts at stroud, OK. Plt added full pwr and returned to Oklahoma City suspecting gear damage. Visual check by another acft revealed no apparent gear damage. Upon touchdown at expressway airpark, the main…NTSB DEN84LA192Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Murdo, SDThe pilot reported the engine failed while he was in a procedure turn. The pilot made a forced landing in an open field and the acft nosed over. Examination of the engine after the accident revealed the engine 'swallowed an exhaust valve' that caused the…NTSB CHI84FA255Accident · 1 fatalField investigationFinal reportRobert B. Boston Glasair RG · Columbus, OHThe plt was on the 2nd leg of a flt to ferry the home-built acft to the lancaster arpt for further testing. After takeoff, he requested clearance to stay in the area for a few minutes. ATC asked him if he had a problem & the plt responded 'no, I just want to…NTSB ATL84LA207Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Parsons, WVThe acft collided with a tree and crashed after becoming lost in IMC weather during a night x-country. The plt had descended after seeing lights below him. He circled the town and made a turn to approach a road for landing on which he said the police had…NTSB ATL84FLT10Accident · No injuriesFinal reportNorth American T-28 · Loudon, TNThe plt reported that he heard a loud bang in the acft eng & it lost pwr & started emmitting smoke. During a forced landing, the acft went thru 4 fences & hit a ditch, and the nose gear collapsed. A fire, which started in flt, destroyed the cockpit after the…NTSB ATL84FKG08Accident · No injuriesFinal reportCessna 177RG · Pell City, ALDuring the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…NTSB ANC84LA098Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Healy, AKShortly after lifting off from an airstrip, the eng lost power. The plt tried to make an emergency landing on a highway, but was unable to reach it. The acft was damaged when he landed in the tops of trees. The reason for the power loss was not found.NTSB SEA84LA154Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Haines, AKThe acft had landed on a short airstrip with a 10 kt headwind. When a takeoff was attempted the wind had stopped, according to the plt, and the acft would not become airborne. The acft went off the departure end of the rwy into underbrush and a gulley. The…NTSB NYC84LA217Accident · No injuriesLimited investigationFinal reportCessna 50M · Middletown, PAThe solo student plt was approaching the rwy to make a landing when the twr gave him go-around instructions due to an shorts 3-30 acft on final. During the go-around the student said he encountered wake turbulence. The acft cartwheeled and came to rest with…NTSB MIA84LA192Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Homestead, FLThe plt reported a loss of directional control occurred during the takeoff ground roll. The acft traveled off the rwy and collided with trees.NTSB MIA84LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt said he had 'cross channeled' his radios & was having communication problems. He decided to land at the opa-locka west arpt. The acft was landed downwind & after overrunning the end of the rwy, it collided with terrain & was damaged.NTSB LAX84LA362Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sacramento, CAThe plt stated he landed a little long on the 2800 foot dirt road and was unable to stop. The acft traveled off the end of the road and collided with a river bank.