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 NYC86LA243Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Seneca Falls, NYThe acft was landed gear up and was subsequently destroyed by fire. The plt admitted he forgot to lower the gear. It wasconfirmed during the post accident inspection that the gear selector was in the up position and the gear doors were closed.NTSB CHI86LA232Accident · Serious injuriesLimited investigationFinal reportMcculloch J-2 · Rush City, MNJust after lift off, while taking off with a tail wind, the plt diverted his attention to the instrument panel & did not realize the gyrocopter was going into an unusual attitude. He said that when he did notice what had happened, he 'just got ready for the…NTSB MKC86LA192Accident · No injuriesLimited investigationFinal reportBeech E55 · Kansas City, MOThe plt rprtd that this was a positioning flt for a 100 hr inspn & that the acft was having electrical problems thru-out the flt. According to him, he extended the flaps & put the gear handle in the down position as he made a VOR apch at night; however, the…NTSB CHI86FEC07Accident · No injuriesFinal reportPiper PA-36-285 · Imlay City, MIThe pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end…NTSB SEA86FA248Accident · 2 fatalField investigationFinal reportCessna 172 · Overton, NVThe UNICOM operator at boulder city made radio contact with '81J' at about 2300 PDT, after hearing an acft maneuvering in the area. The plt stated he did not plan to lnd at boulder city, but said he intended to fly 'up the vegas wash' area. At aprx 2300 to…NTSB ANC86LA160Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · American River, AKAfter landing on a 1200 ft gravel bar, the plt paced off the available area, estimated the load to pick up, then loaded the acft. Due to the x-wind, he used less than takeoff flaps. He began taking off, but after lift-off, the acft 'seemed to hit a…NTSB ANC86FA167Accident · 2 fatalField investigationFinal reportPiper PA-18 · Port Alsworth, AKUndetermined.NTSB LAX86LA344Accident · No injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAThe helicopter departed palomar airport (crq), Carlsbad, CA, on a local instructional flight and was the second flight for the dual student. After completing the flight lesson the student asked the CFI to demonstrate hovering. The CFI initiated an…NTSB ANC86LA149Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Umiat, AKThe airplane departed on September 7, 1986 for a local hunting trip with a client. The airplane did not return and the wreckage was found on September 9, 1986. The airplane was destroyed by post-impact fire. According to the guide, for whom the pilot was…NTSB CHI86FA218Accident · Minor injuriesField investigationFinal reportLearjet 24 · Ypsilanti, MICrew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down…NTSB SEA86FA233Accident · 1 fatalField investigationFinal reportCessna 180 · Wallace, IDPlt received wx brief, advised VFR for proposed flt. Plt filed VFR flt plan and departed. Wreckage located 2 days later at crest of mountain pass.NTSB SEA86LA228Accident · No injuriesLimited investigationFinal reportCessna 152 · Lummi Island, WAThe plt stated he remembers passing arlington, WA, at an alt of aprx 2,000 ft MSL but, remembers nothing else until the acft collided with trees. The plt believes that he fell asleep during the flt.NTSB DEN86MA241Accident · 7 fatalMajor investigationFinal reportCessna 441 · Lander, WYOn 5/1/86, the plt had an acoustic tumor removed fm his rgt ear which included the removal of the 8th nerve (balance nerve). His attending physician suggested aprx a 1 yr period of recuperation due to equilibrium problems associated with this type of surgery.…NTSB ATL86LA229Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Benson, NCThe acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site…NTSB SEA86LA214Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cusick, WAThe pilot was performing as a barnstormer close to a local fair. After completion of several low passes the pilot was attempting to make a steep 180 degree turn to a landing. The turn was completed at insufficient altitude to recover and the aircraft struck…NTSB ANC86FA130Accident · 3 fatalField investigationFinal reportCessna 177RG · Hinchinbrook Is, AKAt 1323 adt, the plt rprtd near Hinchinbrook island & requested clearance for an ndb-a apch to the cordova mile 13 arpt. About 3 min later, cordova fss provided clearance for the apch 'from over Hinchinbrook.' Radar data showed that the acft flew to the…NTSB MKC86LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Republic, MOThe pilot was flying a pattern around a field where he intended to land later. During a low pass, he applied power for a go- around but full power was not sufficient to prevent a touchdown. At touchdown, a side load collapsed the landing gear. The pilot is…NTSB LAX86LA322Accident · 2 fatalLimited investigationFinal reportLuscombe 8F · Marble Canyon, AZWitnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was…NTSB SEA86LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Preston, IDThe jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged.NTSB DEN86FA223Accident · 1 fatalField investigationFinal reportCessna 172 · Ten Sleep, WYThe plt became lost/disoriented and inadvertently entered the narrow canyon in a mountain pass. He attempted to land on a public highway at 7,500 feet MSL when it became apparent the acft would not climb fast enough to clear rapidly rising terrain and that it…NTSB NYC86FA201Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Duxsbury, VTThe plt was on a VFR flight from montpelier, VT to burlington, VT; a distance of about 80 mis. A mountain range is between the two location. Shortly after takeoff the plt radioed burlington approach control and requested an IFR clearance to land at…NTSB LAX86LA317Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Big Bear, CAThe plt planned a cross country flight from palm springs, CA. To the nearby mountain resort community of Big Bear, CA. Enroute, the plt navigated the acft over an area where the terrain was rising at a rate faster than his acft was climbing. The plt attempted…NTSB LAX86FVM07Accident · No injuriesFinal reportCessna 177RG · San Jose, CAThe acft was landed with the gear in the partially extended. Tower personnel attempted to warn the plt of the gear position with use of the radio and light gun signals; however, the landing was continued. Post accident examination of the landing gear system…NTSB DEN86LA222Accident · No injuriesLimited investigationFinal reportBoeing E75 · Tooele, UTThe plt rprtd that he encountered a downdraft while crossing a ridgeline in mountainous terrain, aprx 5 mi NE of Tooele,UT. The elev of the acdnt site was about 9,000 ft & the temp was rprtd by the plt to be 80 deg. This would have resultedin a density alt of…NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…NTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…NTSB DEN86FA216Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Lander, WYThe flt departed Lander, Wyoming, arpt in high density altitude conditions and in an over gross weight condition. The acft was observed flying low over rising terrain until it impacted the ground. The acft was destroyed in a post accident fire and two pax was…NTSB SEA86LA192Accident · Minor injuriesLimited investigationFinal reportCessna 185FII · Reno, NVPlt attempted takeoff with acft 540 pounds over max cert wt and 8500 ft density altitude conditions. Acft became airborne but positive climb and airspeed increase not possible. Plt turned to avoid obstructions, putting acft into semi-controlled collision with…NTSB NYC86FA199Accident · 4 fatalField investigationFinal reportRockwell 114 · Bedford, PAThe acft nearing the close of a x-country flight had requested a decent to start an approach to land at its final destination. ATC had granted the request, but stated to the pilot that he most remain VFR, the pilot acknowledged the clearance. Acft was located…NTSB CHI86FER16Accident · No injuriesFinal reportAero Commander Callair A9B · Argyle, MNWhile setting up for a swath run the pilot struck the ground in a wings level descent. He stated that a 'whirlwind' or 'downdraft' prevented him from pulling up in time to pre-vent impact with the ground.NTSB LAX86LA316Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35 · Marana, AZA Schweizer sgs 1-35, landed hard after a steep final approach. The pilot indicated that he was high on final approach and initially applied 30 degrees of flaps. He was still too high and elected to use 80 degrees (full) flaps. The aircraft landed hard nose…NTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…NTSB MIA86LA223Accident · No injuriesLimited investigationFinal reportBeech J35 · Bunnell, FLThe plt stated that he became distracted & forgot to put the landing gear down. He also stated that the landing gear warning horn was inoperative. Post crash examination revealed that the landing gear warning horn microswitch was out of adjustment.NTSB MIA86LA220Accident · No injuriesLimited investigationFinal reportCessna T337H · Marathon, FLWitnesses reported the pilot arrived for the flight carrying a glass from a local bar, was uncoordinated and appeared intoxicated. After much difficulty in taxiing to the runway, he finally took off. On arrival at Marathon, FL, the pilot failed to extend the…NTSB LAX86FA307Accident · 1 fatalField investigationFinal reportCherry HP16 · Llano, CAThe glider pilot departed on a local flight and the wreckage of his glider was spotted a little over an hour later. There were no known witnesses to the accident which occurred in VFR daylight conditions.NTSB LAX86FA303Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Yosemite Nation, CAAfter flying low over Yosemite national park the Piper PA-32-260, operating as an on-demand passenger flight, climbed eastward into rising terrain. The flight path selected by the pilot was approximately one mile north and 1000 feet higher than tioga pass…NTSB ATL86LA210Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Huntersville, NCPlt was practicing touch-and-go and emer proc. He was high on base and attempted to correct alt, struck a ditch 200 feet short of the rwy with rt ldg gear. Acft came to a stop 100 feet short of rwy in second grass filled ditch.NTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…NTSB CHI86FEV03Accident · 1 fatalFinal reportWoodrow Starduster SA-100 · New Baden, ILThe owner of the single seat, home built, acft offered to allow a navy F-14 plt to fly the plane. The owner made a shortflt, then proceeded to give the F-14 plt a cockpit check. The check-out explaination included such things as the flt characteristics,…NTSB LAX86FVG06Accident · No injuriesFinal reportAmateur Built Barnett J3 · Yuba City, CAThe landing accident occurred after the pilot had made high speed taxi tests along the runway with three liftoffs. After the third liftoff, the pilot said that he found himself too high. He stated that he reduced power and pushed forward on the control stick.…NTSB FTW86LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Sand Springs, OKThe student pilot was hovering aircraft at 3 feet and allowed the aircraft to drift to the right. High skid gear was installed on the a/c. the right skid made contact with the ground causing dynamic rollover. The student pilot had a total of 44.2 hours flight…NTSB CHI86LA187Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Charlevoix, MIAccording to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot…NTSB FTW86LRD22Accident · No injuriesFinal reportGrumman G-164A · Franklin, LADuring aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.NTSB SEA86LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Nahcotta, WAWhile spraying oyster beds the pilot inadvertently flew the helicopter into the ground.NTSB NYC86LA186Accident · Minor injuriesLimited investigationFinal reportMooney M20F · West Milford, NJDrg the landing roll, the plt believed there was insufficient braking, so he initiated a go-around. He rprtd that on climb-out, the tail of the acft impacted a 'hill.' The acft then crashed nose down & was destroyed. No preimpact part failure or malfunction…NTSB FTW86LA137Accident · Serious injuriesLimited investigationFinal reportRose Rhinehart A4-C · Midland, TXThe pilot stated that he encountered severe windshear on approach to landing at the ryan aerodrom airport. He applied full power and pulled the nose up to the best angle of climb attitude, however he could not arrest the sink rate and hit the runway in a…NTSB FTW86LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Houston, TXReportedly the pilot was instructing the co-pilot in quick stop maneuvers, when the helicopter's tail boom and aft skids struck the ground on descent. The helicopter tail boom was bent 2 feet forward of the tail rotor gear box and both aft skids were broken.…NTSB LAX86LA295Accident · Minor injuriesLimited investigationFinal reportCessna T207A · Whitmore, AZThe airplane departed marble canyon airport, marble canyon, Arizona, to pick up passengers at the grand canyon bar ten airstrip (1Z1) for a 14 CFR 135 flight. The pilot reported that upon arrival at 1Z1 he flew over the single dirt strip runway at about 20 ft…NTSB MIA86LA212Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe plt stated that on final approach he forgot to put the landing gear down. He then landed gear up, & the acft slid to a stop.NTSB NYC86LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lock Haven, PAThe pilot made a departure from an uncontrolled airport. During the climb in IMC conditions, the aircraft struck trees and crashed. The aircraft received substantial damage and the pilot received serious injuries. The pilot had a clearance, however, the…