NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 FTW85FA012Accident · 7 fatalField investigationFinal reportConsolidated-Vultee PBY-6A · Port Isabel, TXAerial photos were being taken of the mishap acft. Mission called for a simulated water lndg (actual water lndg prohibited) by flying as close as possible to water. Co-plt at controls descended acft to about 6 ft, then gradually reduced clrnc to 6-12 inches…NTSB FTW85LA008Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Waurika, OKAccording to witnesses, the acft nose was too low at water contact on lndg touchdown and the nose and right pontoon dug into the water. The acft swerved abruptly to the right, flipped inverted and sank. No logs or other floating debris were located during a…NTSB NYC85LA007Accident · Minor injuriesLimited investigationFinal reportCessna 152II · Kinzua, PAAfter demonstrating an approach to a simulated forced lndg, plt elected to climb through a saddle in rising terrain. After entering the saddle, plt realized that acft performance might not be sufficient to out climb terrain at full power. Acft collided with…NTSB CHI85FA004Accident · 1 fatalField investigationFinal reportKallansrud/Pitts S-1C · Overisel, MIMishap acft, in company with another acft of same make/model, made preplanned passes over locale of residence prior to departure for short cross-country. After several circles at 500 ft AGL, mishap plt broke out of loose formation into shallow dive; other plt…NTSB LAX85LA002Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Firebaugh, CAThe acft collided with terrain while on an aerial application flt. The plt stated he, 'heard a loud bang' while spraying. Then the 'nose of the helicopter dove radically down', and he crashed into the field. Examination of the site revealed that one of the…NTSB NYC85LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Waterbury, CTAfter liftoff, the plt initiated a turn into the crosswind to maintain runway heading. As he did so, a wind gust tipped the acft in the direction of the turn. Ground contact occurred before corrective control inputs by the plt could take effect.NTSB MIA85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLThe rated pilot and certified flt instructor stated that they were practicing agricultural dives and turns. During a dive, the pilot pulled out of the dive at about 5 feet and the aircraft contacted sawgrass and crashed. The instructor pilot initially stated…NTSB FTW85LA001Accident · No injuriesLimited investigationFinal reportCessna TU206G · Chandeleur Isl, LAPlt was flying low and slow in area awaiting arrival of boat for fishing party. Plt allowed his attention to be distracted by spotting fish & inadvertently contacted water with a float. Acft came to rest inverted in 6 inches of water.NTSB NYC84LA323Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hazleton, PAAcft departed with full fuel and passenger load near max gross weight, toward rising terrain. After reaching about 400 ft AGL, plt felt acft was losing climb performance, although no signs of power decrease were noted. Acft seemed to be settling. Plt noted…NTSB MKC84LA284Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MOPlt stated that the acft was low on final apch and full pwr was added to go-around. The acft continued to settle until it contacted the rwy. The acft traveled off the left side of the rwy. After continuing through grass the acft contacted a steel angle iron…NTSB ATL84LA295Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Bluefield, WVThe pilot stated that he hovered the helicopter, made a right pedal turn and initiated a hover taxi across a rocky ravine adjacent to the pad. When over the ravine the helicopter settled onto to boulders beneath it. The pilot also stated that he thought he…NTSB CHI84LA399Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Elmo, MNPilot stated that he landed near the approach end of runway 13 and 'right side of aircraft collapsed.' The investigation revealed that the aircraft landed 50 feet to the right side of runway 13. The pilot recorded only a total of 4 hours of night time, 2…NTSB DEN84LA297Accident · No injuriesLimited investigationFinal reportWindecker Research Eagel AC7 · Deming, NMThe acft collided with the rwy gear up after takeoff. The plt said he encountered a microburst which forced the acft to the rwy. There were reported thunderstorms in the area. The plt also said he is going to alter his takeoff proceduresto raising the landing…NTSB DEN84FU011Accident · 1 fatalFinal reportEipper Quicksilver MX · Brighton, COThe ultralight was turning in a spiral turn to the right when witnesses heard the engine stop. The acft went into a spinand crashed. Witnesses said the plt had been doing this before with a pull out at about 50 ft AGL and a restart of the engine. The height…NTSB NYC84LA316Accident · No injuriesLimited investigationFinal reportCessna 182H · Stonington, MEPlt was delayed in return flt to home arpt and arrived at the unlighted strip in darkness. The plt misjudged his runway alignment on approach, colliding with trees 15 ft from the runway during the landing flare.NTSB DEN84FA298Accident · 1 fatalField investigationFinal reportCessna 182P · Glen Canyon, UTThe acft crashed into the 10388 ft high navaho mountain at about the 9800 ft level. Reportedly there was no moon that evening. The plt had departed hayward, CA at 1351 MDT & was enroute to farmington, NM. The acft crashed at 2027 MDT. Investigation revealed…NTSB DEN84FA293Accident · Serious injuriesField investigationFinal reportCessna 172K · Aspen, COAfter takeoff from a valley airstrip in mountainous terrain, plt elected to climb out straight ahead toward rising terrain instead of circling to gain altitude first (normal procedure). Approaching mountain pass, acft was observed climbing below level of the…NTSB MIA84FA253Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Culebra, PRThe plt was advised by other plts that a missed approach was not possible at this arpt on rwy 31. All other plts in the group landed on rwy 13. The accident plt elected 31 until he was on final with a tailwind and then started a go-around. The rising terrain…NTSB DEN84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Canton, SDDuring a descending apch to an unfamiliar cornfield for a swath run, the plt stated he had 'a flashing vision of wires.' The plt pushed the control stick forward to avoid hitting the wires at which time the acft contacted a corn crop in a slight nose down…NTSB ANC84LA172Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Big Lake, AKAccording to the plt, he was taking off from a lake when he decided that he did not have sufficient room to clear trees in his flt path. He aborted the takeoff & the acft settled onto a gravel berm & slid into tundra. The plt believed that the accident would…NTSB ANC84LA180Accident · No injuriesLimited investigationFinal reportCessna U206 · Hartman River, AKThe pilot stated that after takeoff the right gear collided with brush slowing the aircraft. The aircraft then touched down in rough terrain and nosed over.NTSB ANC84FA169Accident · 1 fatalField investigationFinal reportStinson 108 · Hayes River, AKThe plt was on a low level flt to spot wild game when the acft crashed on a gravel drainage bar. A witness stated the acft was flying 5 to 6 ft AGL when the accident occurred.NTSB ATL84FLT14Accident · 2 fatalFinal reportRockwell S-2R · Lake Comorant, MSThe aircraft was taken without permission by an employee of the owner. The employee did not hold an airmens certificate and no record of him ever having flight training could be found. The aircraft was found crashed in a field. No evidence of precrash failure…NTSB DEN84FTM03Accident · No injuriesFinal reportRotorway Rotorway Executive · Lehi, UTThe student plt was practicing hover taxiing at the abandoned arpt. While taxiing the right skid hit a 3 inch high moundof dirt. The acft bounced up and rolled to the left. The plt attempted to correct using the cyclic but the acft began to roll further to…NTSB LAX84FA469Accident · 2 fatalField investigationFinal reportCessna T210J · Valencia, CAWitnesses observed the acft entering a slow roll maneuver. As the acft became inverted, the roll rate decreased, the nose of the acft dropped toward the ground & the plane crashed. No preimpact part failure or malfunction was found. Toxicological checks of…NTSB NYC84LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Monticello, NYAccording to the plt, he was flying instrument approaches to touch and go landings and neglected to extend the landing gear. The automatic gear extension system extended the left main gear before the acft landed.NTSB NYC84FA295Accident · 1 fatalField investigationFinal reportAero Commander 680V · Bridgeport, CTThe acft descended into the water six & 1/2 miles sw of Bridgeport, CT. The acft was on an ILS apch to rwy 06. The acft was in communication with NY TRACON arrvl radar and on his initial call had indicated a desire for a clearance direct tobridgeport. A brief…NTSB ANC84FA166Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Pilot Point, AKAcft departed denai, AK, at 0730 AKDT. When manuevering for a landing apch on dog salmon river acft stalled contacting dirt bank. Plt was carrying 8 5-gallon gasoline cans. 4 cans were still secured inside the acft after the accident. Only 3 of the cans were…NTSB LAX84FUG02Accident · 1 fatalFinal reportPhaneuf B8 MOD Gyro · Murrieta, CAA witness observed the gyrocopter circle the aprt. On the second time around, it dropped down low on the downwind leg and disappeared behind a small hill. He also stated the eng was running at full power and that he could hear the rotor blades strike the…NTSB ATL84LA276Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Leland, MSThe plt said he was attempting a roll at low alt shortly after takeoff and was unable to complete the maneuver before the acft collided with the ground.NTSB ANC84LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKAccording to the plt, he circled the landing area & then began a low pass (upwind leg) at 30 to 40 ft AGL when the acft started to settle. He applied full power, but the acft struck the ground in a level attitude & rolled to a stop in a boulder patch. During…NTSB LAX84FA466Accident · Minor injuriesField investigationFinal reportBeech C-23 · Huntington Bch, CAThe 2330 ft rwy had a 674 ft displaced threshold & power lines near the apch end. The plt reported that during arrival, he made a steep apch with full flaps & min power. After touching down at about midfield, he realized there was insufficient rwy remaining &…NTSB ATL84FA274Accident · 2 fatalField investigationFinal reportCessna 402C · Albertville, ALPlt was executing an non-directional beacon approach to rwy 23. Instrument meteorological conditions prevailed at the time of the accident. Radar information obtained during the investigation revealed the plt did not stabilize the airspeed while executing the…NTSB LAX84FJA02Accident · Serious injuriesFinal reportPiper PA-28-140 · Wailuku Maui, HIThe acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence.NTSB LAX84FA504Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Tucson, AZcontrolled flight into terrain that resulted from the pilot's failure to ensure a safe VFR altitude. The dark night, which restricted the pilot's view of terrain, was a factor in this accident.NTSB LAX84FA459Accident · 5 fatalField investigationFinal reportPiper PA-28-140 · Yucaipa, CAThe acft was observed with its' wing dipping as it flew low over a valley. The acft then touched down in a fld, collidedwith a boulder and a tractor trailer. Examination of the acft disclosed no evidence of a malfunction. The accident site is 6 miles east of…NTSB LAX84LA455Accident · No injuriesLimited investigationFinal reportHughes 269B · Goleta, CAThe student plt was practicing during solo flt and collided with the ground during an aerial taxi. The student explainedthat after a normal landing he pulled enough collective to make the acft light on the skids and proceeded to taxi along the ground by…NTSB NYC84FA294Accident · 2 fatalField investigationFinal reportCessna 414 · Wallingford, VTThe plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…NTSB FTW84LA356Accident · Serious injuriesLimited investigationFinal reportGulfstream 520 · Goliad, TXAcft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.NTSB MKC84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Hill City, KSThe plt cleared some power lines and descended to spray a sunflower field. The acft descended until it contacted the flowers with the landing gear. The tall flowers destroyed the leading edges of the acft wings and the landing gear. The drag slowed the acft…NTSB DEN84LA262Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Kindred, NDThe practice autorotation to touchdown began at 500 ft AGL. Shortly after initiating the flare the tail rotor contacted the ground. The pilot was scheduled for a private pilot helicopter check ride on the afternoon of the accident.NTSB NYC84LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Caldwell, NJThe acft hit the surface of the water during a low pass which was described by a witness as 10-30 ft AGL & done in a series of passes with 'wings wobbling' until the pass that damaged the gear & wing causing the plt & acft to depart the area. Upon returning…NTSB SEA84LA206Accident · No injuriesLimited investigationFinal reportDonald E. Bradshaw Starduster TOO · Whidbey Island, WAWitnesses stated the acft was engaged in aerobatics before it contacted the water and was destroyed.NTSB ATL84IA262Incident · No injuriesIncident investigationFinal reportCessna 150H · Gastonia, NCPlt reached charlotte, NC, and discovered he could not transmit on the acft radio. Plt diverted to gasotnia, NC, but could not locate the arpt because of lowering visibility. Plt flew around for a few minutes looking for identifiable landmarks. Precautionary…NTSB DEN84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Arthur, NDAcft flown at high gross weight in high density altitude conditions. The plt said takeoff pwr was added too late to stopthe descent at the start of a spray run.NTSB MKC84LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Marianna, ARThe landing gear contacted the bean crop which was being sprayed with sodium chlorate and the acft nosed over.NTSB ANC84LA139Accident · No injuriesLimited investigationFinal reportCessna 170B · Barter Island, AKPlt landed on a gravel bar in wilderness for hunting. Two days later, estimating about 1400 ft of usable surface was available for takeoff, he elected to takeoff uphill to take advantage of a slight headwind condition in that direction. The surface of loose…NTSB BFO84FU003Accident · Serious injuriesFinal reportUltralight Flight Phantom · South Boston, VAThe plt arrived at the arpt about 1530 for a demo flt & possible purchase of a phantom Ultralight. The FBO had the plt fly a C-152 from the right seat to familiarize the plt to fly with the control stick on the right & the throttle on the left since this is…NTSB ANC84FA137Accident · No injuriesField investigationFinal reportPiper PA-18A · Mckinley, AKThe acft crashed while attemptng a takeoff from a gravel bar. The plt estimated the useable area for takeoff as 400 to 500 ft. investigation revealed that the density altitude was at least 3400 ft MSL. A test eng run after the acft was recovered, determined…NTSB DEN84LA258Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · New Rockford, NDPlt stated, 'on spray run. Got to close to sunflowers. When I started hitting them on the landing gear the plane slowed down and didn't have enough speed or power to get out so the plane landed in the sunflower field in about 50 yards.' Substantial damage…