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 MKC84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Oelwein, IAThe acft landed gear up. The pilot said he was distracted by the call of another acft on unicum & began looking for thatacft in or near the traffic pattern.NTSB LAX84LA230Accident · Minor injuriesLimited investigationFinal reportNorth American T-6G · Ramona, CAThe plt of a North American T-6G, N1364J, had just landed & was taxiing down a parallel taxiway to the apch end of the rwy to takeoff again. At about the same time, a Cessna 150K, N6402G, had been stopped at the intersection of the parallel taxiway & another…NTSB DEN84FA115Accident · Serious injuriesField investigationFinal reportCessna 172RG · Greeley, COThe acft collided with trees and the ground during a night forced landing. The acft had made some strange sounds and started vibrating after takeoff. A glide was set up for a forced landing. Since the arpt could not be reached a landing was made on a dry…NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…NTSB NYC84LA116Accident · No injuriesLimited investigationFinal reportCessna 336 · Hogansburg, NYThe acft nosed down in a soggy muddy field during a forced landing. The plt reported a power loss on the rear eng and when attempts to restart were unsuccessful made the forced landing into a soggy muddy field.NTSB NYC84FA117Accident · 4 fatalField investigationFinal reportBeech C23 · Champion, PAN23968, crashed into trees shortly after takeoff from rwy 27 at seven springs airport. Plt told the resort manager of seven springs that he could not seem to get airborne & after he did get airborne he could not clear the trees. Investigation revealed the…NTSB LAX84LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 8-24 · Phoenix, AZThe plt took off on a sight-seeing Balloon flt with 5 passengers whose ages were reportedly from 65 to 83 yrs old. About 1 hr & 15 mins later, he landed on desert terrain in winds that he estimated were aprx 10 KTS gusting to 15 KTS. During touchdown, the…NTSB CHI84LA139Accident · No injuriesLimited investigationFinal reportCessna 150M · White Cottage, OHThe student plt became lost during his first solo x-country. He stated that he noticed that the fuel tanks were near empty so he decided to make a precautionary landing. The acft landed in a rough field & struck a plowed furrow. The plt's CFI stated that…NTSB ATL84LA130Accident · Serious injuriesLimited investigationFinal reportPiper J-5A · Forest, VAThe acft was taxied directly to takeoff after being handpropped to start. To the witness who handpropped the acft it appeared to climb at about a 70 degree angle after takeoff and stall before diving nose first into the ground. Engine sounds remained constant…NTSB ATL84FMG03Accident · Minor injuriesFinal reportBowers FLY Baby 1A · New Bern, NCThe plt stated the acft lost lateral control during takeoff. He reduced power and landed the acft off the side of the rwy while maintaining directional control using the rudder. The acft stalled at about 20 ft AGL and was damaged during the hard landing.…NTSB NYC84LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJAccording to the plt, a windshear was encountered during the final approach at approximately 100 ft AGL. The acft descended rapidly and bounced at the approach end of the rwy, ascended approximately 30 ft into the air, landed again striking the left wing on…NTSB MKC84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilson, ARThe acft nosed over during takeoff after hitting a soft spot in the rwy. The takeoff area was a private grass airstrip 1300 ft long. The plt said he had no control of the acft after hitting the soft dirt.NTSB MIA84LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Borinquen, PRThe plt reported that when he initially attempted to start the eng, the battery was weak. He decided to manually remove excess oil/lubricant from the eng by hand propping the acft. The plt stated that he set the parking brake & turned off the master sw & fuel…NTSB LAX84LA228Accident · No injuriesLimited investigationFinal reportCessna 150M · Holbrook, AZThe acft collided with a mound of rubble during an aborted takeoff. The takeoff was attempted uphill to avoid buildings and wires according to the plt. The density alt was 6200 ft. after the collision the acft nosed over.NTSB LAX84FA227Accident · Serious injuriesField investigationFinal reportAero Commander A-98 · Woodbridge, CAThe plt said the acft stalled as he was performing a left climbing turn during aerial application. The acft spun down hitting some oak tree limbs on its way to the ground. The plt had applied all but 200 lbs of his 1450 pounds of ammoniumsulfate.NTSB CHI84LA137Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600 · Detroit, MIThe taxiway collapsed under the acft as the plt prepared for takeoff. The asphalt surface gave way due to sub-surface erosion and a four ft hole resulted. The acfts left main gear was sheared off.NTSB ATL84LA132Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Charlotte, NCUpon landing the nose landing gear sheared off the acft. Exam of the nose gear revealed that two fatigue cracks had propogated to the point of total failure. The gear was the subject of an airworthiness directive that required inspection of the gear…NTSB ATL84FA129Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Woodstock, GAShortly after breaking ground during the takeoff, the engine lost power & the acft came back down to the rwy. The engine regained power & the plt continued the takeoff. The engine again lost power. Subsequently, the acft impacted on an uneven, grassy, open…NTSB SEA84LA074Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Hailey, IDThe student plt attempted to taxi back on the active rwy after landing and groundlooped. During the swerve the left wingcontacted a snow bank. The student plt recommended no tail-up taxiing.NTSB NYC84FA114Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · Oneonta, NYThe acft crashed in a wooded area after the loss of eng power. The wx was VMC. The plt made a missed approach after trying to land on rwy at Oneonta, at 1838 hrs. Later the plt radioed that he was unable to 'pick up' the kring beacon. Boston center vectored…NTSB MKC84LA109Accident · No injuriesLimited investigationFinal reportCessna 188B · Lake Village, ARAs the acft began to rotate during takeoff one propeller blade was thrown 1000 ft behind the acft. The remaining blade and hub became unbalanced, twisting the engine at a 45 degree angle. Plt shut down the engine. Acft traveled off the left side of the rwy…NTSB LAX84LA229Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Lakeport, CAThe plt reported that on his preflight he found the eng compression & oil level to be low but after servicing the oil to the proper level he departed & on initial climb, after reaching about 100 ft AGL, the eng started popping & losing RPM. The plt made a…NTSB DEN84IA116Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Denver, COPrior to taxiing at chicago, the plt had the ramp agent(r/a) check the rear airstair as the aft airstair light on the second officer's panel was 'on'. The r/a recycled the airstair & reported that it appeared closed. The light remained onso the plt referred…NTSB DEN84FTG01Accident · No injuriesFinal reportLee M. Brown Taterbug SB-1 · Sawyer, NDThe plt switched from main tank to aux tank, & about 10 minutes later, the eng began losing power switching back to the main tank did not help. The engine continued running but at greatly reduced power. A forced landing was made in a frozen stubble field. The…NTSB ATL84LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Parchman, MSThe plt reported that during the visual approach to runway 27, he misaligned the acft with the unlighted runway and touched down left of the landing area. The acft collided with a ditch and nosed over.NTSB ANC84LA048Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe plt elected to land on a snow covered strip that had a frozen snow crust & was rutted. He stated that during the touchdown, the acft bounced, then he elected to go around. However, the acft touched down again & broke thru the frozen crust, then nosed over.NTSB LAX84LA226Accident · No injuriesLimited investigationFinal reportCessna 172K · Lancaster, CAThe acft was blown over as it turned crosswind in gusts up to 40 KTS. The plt said he was using the procedures for taxiing in wind conditions. The Cessna 172 is limited to a 15 kt crosswind component for takeoff.NTSB FTW84LA172Accident · Minor injuriesLimited investigationFinal reportRobert Mcdonnell KR-2 · Kerrville, TXAccording to the plt/builder of the home built acft acceleration was not up to par during the takoff roll. Takeoff was continued and initial climb was poor. A downwind turn was initiated at about 100 ft AGL. During the turn the plt noticeda strip of tape on…NTSB CHI84LA136Accident · No injuriesLimited investigationFinal reportCessna 402C · Kenosha, WIThe acft ran off the rwys end after the plt landed downwind to avoid flying through a 'wall of precipation'. During the rollout in slush the brakes froze. The nose gear settled in mud and collapsed.NTSB CHI84LA135Accident · No injuriesLimited investigationFinal reportCessna 421C · Joliet, ILThe acft picked up moderate to severe icing which the pilot thought he had shaken off as he cycled the deice boots. He saw the ice come off of the wings but could not see the horizontal stabilizer. On short final at 100 KTS the control yoke began vibrating.…NTSB CHI84LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · St. Ignace, MIThe pilot took off into adverse wx conditions & failed to attain sufficient altitude to clear trees. The purpose of the flight was to search for a missing acft.NTSB CHI84LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake.NTSB CHI84IA141Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-30 · Moline, ILDuring an apch, the right eng lost power, but an uneventful landing was made. An exam revealed the aft fuel tank, consisting of the #3 & #4 fuel cells, were empty, although the fuel quantity gage indicated 500 lbs of fuel remaining. The erroneous reading was…NTSB ATL84FA126Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Fletcher, NCDuring takeoff the left eng lost power shortly after the landing gear was retracted. The plt stated that he felt the loss of power at about the same time that he turned off the landing lights. With the left eng manifold pressure gauge reading 25 inches hg,…NTSB NYC84FA113Accident · 1 fatalField investigationFinal reportBeech H-18 · Morrisonville, NYThe plt landed on the ice and snow covered rwy after loading 1512 lbs of cargo in freezing drizzle conditions, he taxied for takeoff for an IFR departure shortly after rotation, the right wing dropped and the acft touched down back onthe rwy. Visual exam of…NTSB MKC84IA108Incident · Minor injuriesIncident investigationFinal reportBoeing 727-224 · Kansas City, MOWhile taxiing to rwy 01 for takeoff, the plt noticed a snow removal vehicle operating in reverse, approaching his acft. He tried to maneuver to the rt to avoid a collision but the snow removal vehicle struck the leading edge of the lt wing. The driver of the…NTSB MKC84FA106Accident · 2 fatalField investigationFinal reportBeech B36 · Webb City, MOThe plt was advised by springfield tower that icing conditions existed along his proposed route of flt. However, he elected to takeoff, & about 4 min later, the plt advised that he had encountered rime ice. He continued the flt to joplin, picking up more ice…NTSB LAX84LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Tucson, AZShortly after passing watson intersection inbound to tuscon, AZ the outboard tip of one propeller blade separated. The plt turned the magneto switch off and slowed the acft until the propeller stopped rotating. He then executed an emergency landing short of…NTSB DEN84LA113Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, COAccording to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear.NTSB ATL84LA125Accident · Serious injuriesLimited investigationFinal reportHughes 269 · Supply, NCThe plt and passg stated that as the flt approached Supply, NC, the wx conditions deterioriated and the helicopter encountered a fog bank. The passg recalled that the visibility reduced completely and visual contact with the ground was lost. The plt decided…NTSB MKC84LA107Accident · No injuriesLimited investigationFinal reportCessna 340 · Olathe, KSThe acft skidded off the rwy into slush covered terrain alongside the rwy, dragging the left gear in the mud. As the acft continued its fwd roll the main gear struck the edge of a taxiway & collapsed backwards. The rwy was covered with slush at the time of…NTSB MKC84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, NEDuring landing roll on the runway with crosswind conditions and restricted visibility due to ice on the windshield the acft slid left on the ice and collided with a snow bank, damaging the propeller and the right wing tip.NTSB MKC84FA110Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gasconade, MOThe plt landed at an arpt where, by his own description, the wx was near zero in rain. He then received 2 wx briefings. During the 1st briefing the plt indicated that he could make the flt IFR. The plt was advised of a SIGMET for severe icing conditions at…NTSB MIA84LA125Accident · No injuriesLimited investigationFinal reportCessna 310R · Palm Beach, FLThe acft landed hard, blew the left main tire and ran off the runway. A witness stated 'the pilot came in high on final, chopped power off and landed hard.'NTSB MIA84LA118Accident · Serious injuriesLimited investigationFinal reportCessna 310C · Key West, FLWhile en route, the plt had switched from the main tanks to the aux tanks, then back to the main tanks. About 10 min later, both engs lost power. He was able to restart the right eng, but it lost power again. Subsequently, he ditched the acft at sea. Both…NTSB MIA84LA117Accident · No injuriesLimited investigationFinal reportCessna C-177B · Pahokee, FLAt 0052, shortly after departing big cypress, FL, the plt called west palm beach tower & requested advisories to Pahokee arpt. The controller requested the flt's position, but the plt was not sure of his location. The tower controller contacted miami artc for…NTSB LAX84LA223Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe acft was landed on a highway during a forced landing following a power loss. About 1 quart of fuel was drained from the acft after the accident.NTSB DEN84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12-115 · Riverton, WYThe plt stated that a convair 580 had landed before him. The plt flew a normal glide slope & planned to land on the approach end of the rwy. On short final at 50 ft AGL, the acft suddenly banked 'over 90 degrees' to the left out of control. The acft then hit…NTSB ATL84LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Flemingburg, KYAccording to the plt, the flt was about 12 miles from the airport at 2000 ft when the engine failed. The plt establishedan emerg descent to an open field, ran through a small pond and flipped inverted. Investigation revealed wx conditions conducive to…NTSB ATL84FKG07Accident · No injuriesFinal reportCessna 172P · Atlanta, GAThe plt was having trouble with his radios, electrical system, fuel/eng gages & ammeter, so he turned off his electrical equipment & prepared to make an emergency landing. Because he was afraid of fuel exhaustion, his spacing behind another acft in the…