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 ATL85LA027Accident · No injuriesLimited investigationFinal reportCessna 180J · Harmony, NCThe commercial plt being checked in a tail wheel equipped acft by a CFI on board made 2 successful landings. During the 3rd landing roll, the acft nosed over. The student said that he applied 'heavy' braking during an attempted downslope, short field landing…NTSB MKC85LA016Accident · No injuriesLimited investigationFinal reportCessna 401A · Springfield, MOAfter a gear collapse following a manual extension of landing gear due to an electrical failure the acft was afforded a temporary repair by clamping a wrench to the landing gear strut to 'stiff-leg' it. The gear collapsed again during taxi to the active…NTSB MKC85FA017Accident · 1 fatalField investigationFinal reportPiper PA18-150 · Omaha, ARWitnesses stated that the acft was overflying a portion of tablerock lake near the marina that the plt had intentions of purchasing. The acft struck an unmarked power line that was strung aprx 85 ft above the lake. The acft collided with the water and sank.…NTSB MIA85LA025Accident · No injuriesLimited investigationFinal reportCessna 310C · Ocala, FLThe acft started its ground run and upon encountering a dip in the rwy, the acft became airborne. The engines lost power shortly thereafter and the acft collided that a fence and hay bales. The acft owner stated that the plt (a prospective buyer of the acft)…NTSB DEN85LA023Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Denver, COAccording to the pilot, the acft was taxiing to park when a small truck was seen approaching from the right about 50 ft away. After realizing that the vehicle driver did not see the acft the pilot reduced power to idle and applied the brakes. The truck driver…NTSB CHI85LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Pillager, MNThe plt took off uphill on a grass rwy that was dew covered. The field was aprx 1600 ft long bordered by 50-75 ft trees. The plt stated that during takeoff roll the acft lights were flickering. He said that the acft was airborne aprx 300 ft before reaching…NTSB BFO85FA006Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Waterford, VAThe aircraft was observed flying around the airstrip at dusk. As it passed over the aprx center of the field it was seen to nose over into a steep angle continuing until impact. Investigation revealed no evidence of any mal funtion of the aircraft or the…NTSB SEA85LA015Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Ely, NVThe acft crashed in a swampy area during a forced landing after a power loss. The plt said he had a rise in oil temp andwas cruising at a lower alt to stabilize the oil temp. This necessitated navigating around some mountains which increased the flt distance.…NTSB SEA85LA014Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Lakeside, ORThe acft collided with power lines during a takeoff from a remote logging camp. The plt reported hearing a loud bang during takeoff. He said that the acft pitched right and nosed down. 'The acft spun to the right without power. The acft came to rest…NTSB NYC85LA023Accident · No injuriesLimited investigationFinal reportBeech BE-55E · Groton, CTAs the acft broke out of the 300 overcast layer the plt saw birds flying off of the rwy threshold. Due to IFR conditions and low altitude the plt elected not to go around. The tower advised the plt of the birds on 2 mile final on the ILS apch.NTSB MIA84LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Miami, FLWhile cruising at 800 ft MSL the plt statd that the eng sputtered and lost all pwr as he opened the throttle. During the ensuing forced landing the plt veered to the left because of a bldg located at the end of the field. The acft collided with trees. An eng…NTSB LAX85IA040Incident · No injuriesIncident investigationFinal reportWestland Helicopters WG30 · Santa Ana, CADuring a climb to cruise, the crew experienced control difficulties when the for-&-aft trim actuator began to motor forward and would not stop. An emerg descent was made with both plts exerting aft cyclic pressure to prevent the speed from increasing over 120…NTSB FTW85LA038Accident · No injuriesLimited investigationFinal reportCessna 150K · Paris, TXThe acft was being flown to a nearby facility for refueling. Fuel exhaustion occurred en route. The plt set up a full flaps descent and collided with trees on landing.NTSB FTW85LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · New Orleans, LAAccording to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI…NTSB CHI85IA039Incident · No injuriesIncident investigationFinal reportRockwell NA-265-25 · Chicago, ILAcft control was temporarily lost when 36 degrees of flaps were added due to ice build-up behind heated leading edge of the wing. Raising the flaps to 20 degs alleviated the control problem and an uneventful landing was accomplished at a higher than normal…NTSB NYC85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oxford, CTAfter entering the traffic pattern for the selected runway, plt was informed of surface wind conditions and elected to continue and execute a downwind landing. Upon touchdown, plt raised flaps to assist braking action. During roll-out the plt decided…NTSB MKC85LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Oxford, IADue to a lower than optimum glide path and turbulence, the acft landed about 100 ft short of the rwy. All 3 landing gear collapsed in the unimproved terrain.NTSB MIA85LA024Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Davie, FLPlt stated he was practicing maneuvers and when he added pwr after one maneuver the eng did not develope 'full RPM.' He went through emergency procedures but could not effect a recovery of power so he elected to land. The field chosen was soft and wet. The…NTSB MIA85FA023Accident · 2 fatalField investigationFinal reportBeech C23 · Crestview, FLDuring arrival, the plt was cleared for an ILS apch. The reported wx at that time was: 600 ft overcast, visibility 7 mi, wind 010 deg at 6 KTS. The plt stated that during the apch, he felt a downdraft that caused the acft to bank to the left & pitch down. The…NTSB LAX85LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sanger, CAUpon touchdown, the left main landing gear contacted a pothole in the rwy aprx 175 ft from the threshold. Skid marks from the left main tire were seen on the rwy beginning at that point along with metal scrappings from the gear. Shortly thereafter, skid marks…NTSB FTW85LA043Accident · No injuriesLimited investigationFinal reportBell 47D1 · Terlingua, TXShortly after the plt took off on a sight-seeing flt, the eng lost power when the helicopter was over rough terrain at about 200 ft AGL. During an autorotative landing, the helicopter rocked forward causing the main rotor blades to strike the tail boom.…NTSB FTW85FA037Accident · Serious injuriesField investigationFinal reportCessna 182A · Mckinney, TXThe plt stated, he had departed the aero county airport, Mckinney, TX, on a local flt to drop sky divers. He dropped the sky divers & was returning to the arpt when he encountered a loss of eng power & made a forced landing. He stated that he pulled on…NTSB BFO85FA005Accident · 2 fatalField investigationFinal reportDouglas AD-4NA · Syria, VAThe plt had obtained two wx briefings bfr the flt both indicating VFR not recommended. He said he would fly VFR as long as he could along a northern route that was forecast to be VFR deteriorating to MVFR. The plt was not instrument rated. The acft was…NTSB ATL85FLT03Accident · Serious injuriesFinal reportCessna T210N · Soddy Daisey, TNThe acft descended into trees during IFR weather after having a ttl electrical failure. The plt continued navigating by dead reckoning and not finding a break in the clouds decided to descend through the clouds. The tops of trees were struck on a ridge at the…NTSB NYC85FFJ01Accident · Serious injuriesFinal reportStevens MONNETT-MONI · Endicott, NYThe acft collided with the terrain in an uncontrolled descent following a partial loss of power during a takeoff climb. The plt stated the RPM dropped from 5200 to 4600 at which time he attempted to lean the mixture. A severe vibration developed and not…NTSB MKC85LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Springfield, MOThe acft collided with trees during a forced landing, while on a dual instructional flt. The CFI said after the climb tocruise the eng began to slow dwn. The CFI took control of the acft to return to arpt of departure. He said the vibrationwas excessive as…NTSB MIA85FA022Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Jasper, FLDue to a low fuel state the plt elected to make a precautionary landing on a road. Power lines and poles forced the plt to land in unimproved terrain next to the road. During touch down the left wing struck a dirt bank. Exam of the wreckage revealed that 3…NTSB LAX85FA038Accident · 1 fatalField investigationFinal reportStinson Voyager 150 · Meadow Vista, CAThe acft collided with terrain while maneuvering northeast of auburn airport during a VFR personal flt. The plt advised sacramento TRACON that he had auburn arpt in sight. However, TRACON observed N97638 fly over & pass auburn arpt in a northerly direction &…NTSB FTW85LA035Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Sonora, TXPilot stated that he intended to land at Sonora, TX, but patchy ground fog obscured the arpt. He circled the aprt one time and then departed northward. He turned back to attempt another visual approach to the arpt when the aircraft struck a tree on the…NTSB CHI85LA044Accident · Serious injuriesLimited investigationFinal reportWells KR-2 · Delaware, OHAccording to the plt, he made a normal takeoff in his home built acft & started to climb on a flt path that went over a warehouse. He reported that he encountered a thermal & severe turbulence which were created by the warehouse. He stated that this caused…NTSB CHI85LA040Accident · No injuriesLimited investigationFinal reportCessna 150M · Wyatt, INWhile practicing ground reference maneuvers at 800 ft AGL the engine power dropped from 2,500 to 1,500 RPM. During the forced landing rollout the nose gear collapsed when it contacted a dirt bank. Investigation revealed that the throttle control rod end bolt…NTSB CHI85LA038Accident · No injuriesLimited investigationFinal reportCessna 310C · Grayslake, ILThe plt reported that the landing was normal but the acft settled to the rwy with the gear up while the selector was in the down position. Post accident examination failed to reveal any malfunction of the retraction/extension assembly.NTSB CHI85LA037Accident · No injuriesLimited investigationFinal reportKragnes Acrosport II · Moorhead, MNAfter 20 min flight, engine lost power due to fuel exhaustion. Plt executed forced lndg in rough field, acft nosed over on contact with uneven terrain during lndg roll. Plt stated he must have measured fuel quantity incorrectly during last refueling. Acft not…NTSB CHI85IA042Incident · No injuriesIncident investigationFinal reportCessna T210L · Wheeling, ILDuring a preflt, just prior to takeoff, the plt checked the flt controls & full travel of the controls was achieved. He initiated the takeoff, but when he applied back pressure on the elevator control, it would only move about 1 inch. He aborted the takeoff…NTSB ATL85LA026Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bay St. Louis, MSPrior to departing on a flt from arlington, TX, to gulfport, MS, the plt stated that he checked and found the fuel tanks full. About 17 miles from gulfport the fuel gage showed a rapid loss of fuel at which time the plt switched tanks. Two minutes later there…NTSB NYC85LA018Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Laconia, NHAccording to the plt, shortly after takeoff the acft began to pitch up, decelerate, and roll right. He reduced power and lowered the nose in an unsuccessfull attempt to regain control. There were no mechanical malfunctions reported.NTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…NTSB MKC85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Aurora, MOThe acft was landed gear up. The student plt put the gear down on downwind and then on a pre-landing check on final apchthe student retracted the gear. The CFI said the warning horn never sounded and she did not notice that the gear was up.NTSB LAX85IA037Incident · No injuriesIncident investigationFinal reportBoeing 747-131 · Los Angeles, CADuring darkness, a Boeing 747, N93106, was being taxied for departure when its left wing collided with the right wing of a Boeing 767 being towed in the same direction on a parallel taxiway. Both crews had obtained ground control clearances to perform their…NTSB FTW85FA034Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · El Reno, OKThe acft was destroyed on impact with the ground after being observed by ground witnesses to go out of control during anaerobatic maneuver. There was a difference of opinions as to what happened. One witness described the ground collision having been from an…NTSB CHI85LA043Accident · No injuriesLimited investigationFinal reportRockwell AC-112A · Columbus, OHThe acft experienced a main gear collapse during a landing roll. The plt claimed that the acft suffered a failure of theelectrical system shortly after initial takeoff. The plt lowered the lndg gear but was unable to achieve a gear down & locked indication…NTSB NYC85LA017Accident · No injuriesLimited investigationFinal reportCessna 172P · Andes, NYAccording to the plt, he encountered deteriorating visibility due to haze & he elected to land in an unimproved field. The 1st approach was aborted; however, the acft touched down on the 2nd approach. After touching down, the plt realized the field was too…NTSB MKC85FA012Accident · 3 fatalField investigationFinal reportMooney M20E · Carbondale, KSThe flt was en route from little rock, AR, to topeka, ka. Ten miles south of topeka's frobes field the plt requested wx info and was told that a current observation was being taken & he would be advised. Contact between the tower and the flt could not be…NTSB FTW85LA070Accident · No injuriesLimited investigationFinal reportCessna P210N · Big Lake, TXEn route to his destination the plt was advised of IMC at the destination and elected to return to the arpt from which he had departed. The acft collided with the rwy gear up because the plt delayed gear extension during the landing.NTSB ATL85LA025Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600A · Charlotte, NCDuring final approach the pilot was unable to lower the nose gear therefore he landed with the nose gear retracted. Post crash examination revealed that the nose steering actuating bolt was fractured. The facture surfaces exhibited signatures of a progressive…NTSB ANC85LA019Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe plt stated during two telephone interviews that he hit trees during takeoff and then continued his two hour flt to to the homer arpt. The left wing was damaged and both left and right sides of the horizontal stabilizer were crushed andbent up about 19…NTSB MKC85LA011Accident · No injuriesLimited investigationFinal reportCessna 310J · Chanute, KSDuring the landing roll the left main landing gear collapsed. Examination of the acft after the accident revealed several mechanical discrepancies. The only gear related problem noted was the landing gear limit switches were out of adjustment but it could not…NTSB LAX85FUG01Accident · No injuriesFinal reportCessna 195 · Riverside, CAThe acft nosed over during a landing roll following a loss of control.NTSB LAX85FA036Accident · 2 fatalField investigationFinal reportBell 206B · Beaumont, CAApproximately one min before the accident the pilot contacted the tower at norton air force base for clearance through their traffic area. He reported initially that he was at 300 ft AGL. Seconds later he transmitted that he was at 100 ft over the freeway.…NTSB FTW85LA033Accident · No injuriesLimited investigationFinal reportStinson 108 · Sandia, TXThe plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees…