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 LAX85FVG01Accident · No injuriesFinal reportCessna 152 · Lower Lake, CAThe acft contacted trees while attempting to land at hoberg airstrip.NTSB LAX85FA193Accident · Minor injuriesField investigationFinal reportCessna 150M · Fullerton, CAGnd witness & the student plt rptd upon touchdown the acft began to bounce. After several bounces the plt began to go-around upon reaching midfield. After lift off the acft began to sink and collided with the arpt boundary fence. When executing the go-around…NTSB LAX85FA192Accident · 2 fatalField investigationFinal reportCessna 150L · Corona, CAThe student & instructor plt (CFI) were on a local instructional flt. The student had flown a total of only 3 hrs prior to this flt. Just before the accident, the acft was observed spinning toward the ground in a near vertical descent. It impacted in an…NTSB FTW85LA172Accident · No injuriesLimited investigationFinal reportMooney M20A · Austin, TXThe 86 hr private plt landed at a ranch and ran off the end of the rwy into rough terrain. A go around was not attempted.NTSB DEN85LA108Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Fort Collins, COThe plt of a Maule lost directional control during an attempted landing at a dirt strip near ft collings, CO. The wind was from the west at a full landing stall attitude when a gust of wind picked the rt wg up causing the left wing to contact the ground.…NTSB DEN85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Kemmerer, WYOn April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to…NTSB NYC85FA092Accident · Minor injuriesField investigationFinal reportSikorsky S-55B · Port Elizabeth, NJThe helicopter landed hard after a decrease in RPM during initial climb. The acft was being used for a sling operation. Investigation revealed a failed clutch assembly, S1435-2500-1. The clutch had operated only 200 hrs since a major overhaul.NTSB MKC85LA081Accident · No injuriesLimited investigationFinal reportEhlers Starduster ESA300 · Kansas City, MOThe plt stated that during the landing roll he noticed an acft landing behind his and therefore veered his acft to the right of rwy 36 traveling about 45 mph. During the maneuver the plt felt the right gear give and the acft consequently ground looped twice…NTSB MKC85FA080Accident · 1 fatalField investigationFinal reportGulfstream-Schweizer G-164B · Garland, ARThe plt was beginning a spray run over a wheat field when the acft impacted the top 3 strands of a 4 strand, high voltage power line. The acft then descended uncontrolled until impact with the terrain.NTSB FTW85FPJ01Accident · Serious injuriesFinal reportGrumman AG CAT G-164 · Norman, OKThe acft collided with a high static wire on an electric transmission line before colliding out of control with the ground. The plt stated after the accident that he forgot about the static line and flew into it during a maneuver for aerial spraying.NTSB FTW85FA171Accident · 1 fatalField investigationFinal reportCessna T210N · Riesel, TXThe acft eng had just been top overhauled and a stol kit was added. The mechanic reportedly told the plt to be 'easy' on the eng and fly the acft 45-60 mins near the traffic pattern so it could be checked for oil leaks. The plt reportedlyignored these…NTSB DEN85LA106Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTOn April 1, 1985, a Cessna 210 with mexican registry, xbcke,piloted by a mexican national, lost engine power and landed short of the runway at Salt Lake City international airport the flight had depated the grand canyon AZ airport. Post accident examination…NTSB NYC85LA096Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsfield, MADuring a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered…NTSB NYC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Red Hook, NYDuring flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.…NTSB MIA85FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Rockledge, FLOn March 31, 1985 the rental acft departed merritt island flon April 1, 1985 the acft was found crashed near Rockledge FL. No evidence of pre-existing airframe or powerplant failure was found. The acft impactd the ground in a high velocity 40 degree nose down…NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…NTSB LAX85LA194Accident · Serious injuriesLimited investigationFinal reportBell 206A · San Diego, CADuring flt, the eng lost power & the plt began an autorotative landing in a parking lot. During the apch, he maneuvered to avoid a 100 ft crane. As the helicopter was approaching the intended touchdown point, a vehicle was driven into the flt path of the…NTSB LAX85FUQ02Accident · No injuriesFinal reportCessna 150H · Sylmar, CAThe acft eng quit during a return from a x-country flt. The plt stated that nearing the end of his flt the acft encountered turbulence over the mts and he climbed to 7500 ft in search of smoother air. Shortly afterwards he started a slow descent from 7500 ft…NTSB LAX85FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Anza, CAAfter making two previous takeoffs and one landing in an overloaded airplane the pilot landed about 1000 feet down a 3200 foot runway. When the aircraft failed to decelerate quickly enough and the pilot attempted a go-around toward rising terrain. The…NTSB FTW85LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Matagorda Is., TXThe pilot executed a VFR go-around while on final approach due to livestock on the runway and reportedly experienced engine power loss. The aircraft made a forced landing on the beach and flipped inverted, coming to rest in the water alongside the beach. The…NTSB DEN85LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Logan, UTThe acft departed the rwy during a touch and go landing. The plt stated that after touchdown, the acft pulled to the right. The acft impacted a snowbank to adjacent to the rwy and nosed over. It was reported that the plt had applied wheel brakes with the…NTSB DEN85LA104Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Casper, WYBefore reaching the destination, the acft encountered turbulence & the passenger became ill. The plt tried to land on the east-west rwy, but the x-wind was too strong, so he then entered a pattern for rwy 3. After turning into the wind for a landing, the acft…NTSB BFO85FA032Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Roanoke, VAThe plt reported he ran a fuel tank dry during flt at 6000 ft. he switched fuel tanks, turned on the boost pump & manip-ulated the eng controls, but was unable to restart the eng. During a forced landing on I-581, the acft struck a pickup truck (traveling in…NTSB ATL85LA125Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Blairsville, GAThe private pilot and his student plt passenger were departing the a/p when the plt made a sharp turn downwind at about 100 ft of alt. The a/c mashed into the ground bounced and landed in small trees. The nearest reported winds were recorded at 19 KTS. The…NTSB SEA85LA081Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Trinidad, WAThe pilot was operating the aircraft by flying at low altitude down the columbia river so as to avoid turbulence. During the flight a downdraft was encountered in which insufficient altitude was available to prevent the water and an unintentional ditching…NTSB NYC85LA093Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Orange, MAThe plt reported he was flying at about 25 ft above water. As the acft crossed over a grass covered sand bar, the gear encountered 'swail grass' & the acft was 'dragged in.' The plt also reported that the acft had encountered turbulence; however, a witness…NTSB MIA85LA138Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Key Largo, FLThe acft departed tavernaro arpt with an estimated 3 to 4 gallons of fuel on board & proceeded northeast to port Largo arpt, executed two touch & go landings, departed the pattern & approximately 6 miles northeast of port Largo arpt the eng started to run…NTSB MIA85IA137Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe acft veered off the left side of rwy 9R on landing. Inspection of the acft revealed that the torque link washers on the left main landing gear had failed allowing the wheel assembly to rotate causing the loss of directional control. No record of…NTSB LAX85LVM03Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CAThe plt stated he intended to climb over a pwr line at the end of a swath run, however, a tailwind gust was encountered and the acft could not obtain sufficient altitude to clear the line. The plt elected to fly under the line unaware of a lower line which…NTSB DEN85LA098Accident · No injuriesLimited investigationFinal reportCessna 402C · Aspen, COThe plt was given instructions by the Aspen twr controller to land on rwy 15. He was requested to make a short final to the rwy because of approaching traffic. The pilot stated that he landed slightly left of the rwy ctr line. The acft skidded to left and the…NTSB ATL85LA128Accident · No injuriesLimited investigationFinal reportVarieze Duncan/Varieze · Ocracoke, NCDuring landing, the tab which connects the landing gear cross tube failed allowing the right gear to collapse. The acft has an experimental certificate. The failure appeared to be due to design limitations.NTSB ATL85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Blairsville, GADuring flt, the plt encountered unfavorable winds & rain, then became concerned about his fuel supply. He diverted to Blairsville & was landing when a gust of wind blew the acft side ways. The plt re-aligned the acft with the rwy, but it suddenly dropped &…NTSB ANC85LA061Accident · No injuriesLimited investigationFinal reportCessna 150C · Kenai, AKThe pilot was on a local pleasure sightseeing trip when the engine quit; the pilot attempted a forced landing on a road. Just before touchdown the aircraft struck two power lines. The pilot stated that he ran out of fuel and he believed that he had enough…NTSB MKC85LA079Accident · No injuriesLimited investigationFinal reportCessna 188 · Osage City, KSThe plt was practicing landing at the airport when during the landing roll on the third attempt at landing the acft swerved off the rwy. The acft ground looped after departing the rwy and sustained substantial damage. The plt rptd the brakes grabbed…NTSB MIA85LA136Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Melbourne, FLThe acft was departing on rwy 27L, when aprx 1200 ft down the rwy, on the takeoff roll, it veered off the left side of the rwy & crossed two taxiways. The acft came to rest about 350 ft off the left side of rwy 27L. A post crash exam of the landing gear…NTSB LAX85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Death Valley, CADuring a flt from reno, NV to phoenix, AZ, there was a partial power loss in the left eng as the acft was climbing thru 15,000 ft with an outside air temp of -15 deg. The fuel selectors could not be moved, so the plt retarded the right eng power & descended.…NTSB FTW85IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-200B · Mexico City, MexicoDuring the initial climb after takeoff a 27 foot tall light pole was struck by the right main landing gear 1,677 feet from the end of the rwy. Acft gross weight dictated a 5 deg flap takeoff and company performance data authorized departure on either rwy 5R…NTSB DEN85FA103Accident · 1 fatalField investigationFinal reportGulfstream 681 · Calhan, CODuring a xcountry flt from WI to CA and return, the noninst, low experienced pvt plt, flew into IMC conditions. The acft impacted flat snow-covered grd, destroying the acft and fatally injuring his pax. Exam of wreckage revealed no evidence of pre-acc…NTSB CHI85LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Richmond, INWhile on a solo training flt the student plt allowed the acft to bounce during touchdown. The acft then became airborne & stalled while several feet above the rwy. During the ensuing hard landing the nose gear strut collapsed & the acft veered to the left…NTSB LAX85LVD01Accident · No injuriesFinal reportPiper PA-24-250 · Navato, CAThe acft was landed gear up. The plt stated that as he retarded the throttle to land the lndg gear warning sounded. He applied power but the acft touched down with a scraping noise. He does not remember seeing a green lite for gear dwn indication.…NTSB FTW85LA166Accident · No injuriesLimited investigationFinal reportCessna TU206G · El Paso, TXAcft being taxiied to ramp after landing with wind 27 KTS gusting to 42 KTS. A gust of wind lifted the right wing and the acft nosed over.NTSB SEA85IA080Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-14 · Reno, NVAfter a ground time of 36 minutes during rain/wet snow the aircraft departed Reno. During the climb in below freezing conditions the crew experienced elevator pitch control difficulties which persisted until the descent into seattle. Examination of the…NTSB MKC85FA078Accident · 2 fatalField investigationFinal reportCessna 182A · Onxy, ARAt 1230 CST on 3/27/85, the plt & his wife departed on a x-country flt, but did not arrive at their destination. When family members became concerned, a search was initiated. The wreckage was located on 3/31/85 where the acft collided with trees & crashed on…NTSB MIA85LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Key West, FLAfter the acft departed the seaplane parking area, the plt noticed that the left float was taking on water. He initiated a turn back towards the ramp area & applied full power in an attempt to reach shallower water. As he apchd the parking area & was turning…NTSB MIA85LA134Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Tampa, FLThe plt stated that during takeoff from rwy 17, the right eng lost power at an alt of about 50 to 60 ft. he attempted toturn back & land, but touched down 90 deg to rwy 03 & slid aprx 100 yards, collapsing the landing gear & separating the right wing from the…NTSB LAX85LA189Accident · No injuriesLimited investigationFinal reportCessna 172G · Show Low, AZInstructor plt stated that prior to departure for Show Low he called the fixed base operator at Show Low and learned the winds were currently from 190 to 200 degrees a 20 T0 30 knots. He and his student departed and upon arriving in the Show Low area learned…NTSB BFO85LA030Accident · No injuriesLimited investigationFinal reportCessna 182G · Bridgewater, VADue to excess altitude, during his 1st apch to land, the plt executed a go-around. The 2nd apch resulted in proper altitude, but high airspeed. Crosswind conditions & gusts up to 22 KTS existed at the time & touchdown occurred aprx half way down the 2755 ft…NTSB NYC85LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Clearfield, PAThe acft veered off the rwy and collided with a drainage ditch during touchdown. The plt stated that during the apch to the arpt, the acft flew over a coal stripping mine which produced turbulence and resulted in a touchdown without proper alignment with the…NTSB MIA85LA133Accident · No injuriesLimited investigationFinal reportHughes 269C · Tampa, FLThe instructor plt (CFI) reported that while practicing a taxi/hover autorotation, the helicopter settled onto a soft area in the turf. He reported that the student over-controlled with right anti-torque pedal & the helicopter settled in a left skid. The CFI…NTSB FTW85LA165Accident · No injuriesLimited investigationFinal reportCessna 206 · Pharr, TXThe aircraft is mexican registered and was being flown by a mexican national, from mcallen TX. To tuxpan ver. Mexico. Its cargo was television sets. About five minutes after departing mcallen the pilot reported a power loss and that he was returning to the…