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 MIA82DA062Accident · 1 fatalFinal reportCessna 150 · Huma Cao, PRThe aircraft was reported to have departed at or near sunset on a 30 minute aerobatic flight and did not return. During that period, an aircraft matching its description was observed to crash near by in the ocean while the pilot was performing aerobatics. A…NTSB FTW82DA082Accident · No injuriesFinal reportStarduster II · Taylor, TXDuring a slow roll to the left, the aircraft developed a high rate of descent. The roll was completed just before ground impact which demolished the aircraft.NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…NTSB FTW82FQA14Accident · 2 fatalFinal reportCessna 182Q · Fort Sumner, NMThe plane crashed and burned on a dark moonless night after impacting in a nose low attitude. The crash site was located near the home of the pilot's friend where the pilot had visited earlier in the evening. After impacting in soft, level, sandy soil, the…NTSB DEN82FTM09Accident · 1 fatalFinal reportBeech A36 · St. George, UTThe aircraft was on a flight from las vegas, Nevada to St. George, Utah when it flew past the destination and struck the side of a mountain. The crash site was located about 15 miles beyond the destination at an elevation of about 7600 ft MSL. The site was…NTSB FTW82FQA13Accident · Serious injuriesFinal reportPiper PA-28RT-201T · Toadlena, NMThe non-instrument rated pilot in Piper PA-28RT, N29665, was using a call sign, N1104X, which was the registration number of a destroyed PA-32. He was cleared to climb to FL200, but as he continued, his speech became slurred. He acknowledged an artc…NTSB ATL82FA055Accident · 8 fatalField investigationFinal reportPiper PA-31T2 · Springfield, KYThe flt was cleared to maintain 3,000 ft MSL until over the arpt, then cruise. The plt had previously stated that he could see the lights on the ground & that he was 15 mi from the arpt. At 2013 the plt stated "we oughta be able to cancel here." The acft…NTSB LAX82FA074Accident · 1 fatalField investigationFinal reportPiper PA-34 · Near Sonoma, CAThe pilot proceeded VFR toward a private strip after an instrument approach to napa county airport. The visibility was not good and the aircraft collided with a hillside while en route. About 5 mi north, the weather at the napa county airport was 500 ft…NTSB CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…NTSB MIA82FLD15Accident · Serious injuriesFinal reportPiper PA-31 · Ft. Pierce, FLThe aircraft crashed at night near a private strip in marginal weather conditions. The gear was found in the up position, the right engine was broken off, the nose section was crushed back to the windshield, and both propellers were bent and twisted. About…NTSB MIA82FA042Accident · 2 fatalField investigationFinal reportRobinson R-22 · Ormand Beach, FLAfter being told by the operator to remain on the ground until the weather improved the instructor pilot departed ormond Beach airport. The pilot radioed daytona Beach approach control and requested a special VFR clearance and vectors to daytona Beach…NTSB NYC82FA029Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Newburgh, NYAt 2234 the plt was issued a vector to the initial approach fix for the ILS rwy 9 apch. He was also issued the followingwx "...stewart weather thirty minutes ago is estimated one thousand overcast six miles in light rain and haze." At 2238 the plt was advised…NTSB FTW82FRD08Accident · 2 fatalFinal reportCessna 150G · Jeanerette, LAAccording to a friend of the deceased pilot and his female companion the three of them had been at a nightclub until 0215 CST. The friend then followed them to the airport, since he lived adjacent to the airport. After arriving he heard an aircraft takoeff.…NTSB DEN82DA028Accident · Serious injuriesFinal reportPiper PA-32 · Rock Springs, WYThe aircraft departed vernal,ut at 1810 MST after refueling. During the VFR flight the pilot reported to Rock Springs fss that he was 20 miles south and was given current weather and runway in use. No other transmissions were received. The aircraft struck a…NTSB CHI82DA033Accident · No injuriesFinal reportGrumman 1159 · Anderson, INBefore the aircraft arrived, the snow covered runway was plowed. A Cessna 182 pilot previously reported the braking action as fair to poor. The aircrew decided to land as close to the approach end as possible. The pilot reported that he had not been advised…NTSB NYC82DA017Accident · No injuriesFinal reportCessna 150L · Caldwell, NJThe student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The…NTSB DEN82DA025Accident · No injuriesFinal reportCessna 172 · Near Gillete, WYThe purpose of the flight was to make an aerial survey for livestock. During flight, the observer noted some cattle in a cove. The pilot then turned and descended to about 100 feet AGL. After leveling, he noted that he would have to climb or turn to avoid…NTSB LAX82DA060Accident · No injuriesFinal reportCessna 172M · Carson City, NVThe aircraft struck an 18 inch high frozen snow bank that a snow plow had left stretched across the approach end of runway 09. The pilot not able to see the snow bank due to fresh fallen snow. The right main gear was sheared off and the aircraft slid to a…NTSB LAX82FUJ25Accident · Serious injuriesFinal reportPiper PA-23-250 · Bagdad, AZThe pilot attempted to fly from phoenix to Bagdad, AZ under a low overcast. When it became obvious that weather conditions were too poor for a landing the pilot attempted to reverse direction and the aircraft struck high terrain.NTSB ANC82DA016Accident · Minor injuriesFinal reportCessna 207 · Port Graham, AKThe pilot reported that during a base to final turn, the aircraft was blown slightly off the center line of the runway. Also, he reported encountering a wind shear effect from a nearby bluff. As the plane drifted to the right, it commenced a high sink rate…NTSB MIA82FA034Accident · No injuriesField investigationFinal reportCanadair CL-44D4 · Miami, FLDuring gear retraction, there was a loss of hydraulic pressure after the nose gear came up and was locked, but while the main gear was in-transient. The pressure raised to 300 PSI when the auxiliary hydraulic pump was turned on, but dropped rapidly back to…NTSB LAX82FA047Accident · 1 fatalField investigationFinal reportCessna 172M · Downieville, CAThe aircraft departed yuba city about 1030 PST after the pilot received a partial weather briefing from the marysville flight service station in which VFR flight was not recommended. Radar plots on the aircraft indicate a non-linear flight path from the…NTSB LAX82FUQ08Accident · 1 fatalFinal reportBede BD-5B · Mojave, CAAfter takeoff the amateur built Bede-5 entered left traffic and circled the airport once at 700 to 1000 feet AGL. During the second 180 degree turn from the downwind leg to the runway heading a witness reported that the bank angle suddenly increased and the…NTSB DEN82DA019Accident · No injuriesFinal reportCessna 180E · Cedar City, UTThe pilot stated that he intended to fly close to the field surface dragging the tailwheel of the aircraft to determine snow/field conditions. During the low pass he used three notches of flap and added full power with the propeller at full pitch. When the…NTSB ANC82DAG15Accident · No injuriesFinal reportCessna 170B · Tuluksak, AKThe pilot reported that on returning to bethel the weather was bad so he landed at Tuluksak. The weather cleared and the pilot attempted to return to bethel. After takeoff the pilot stated that he lost visual contact with the ground during a 180 degree turn…NTSB SEA82DA019Accident · No injuriesFinal reportHughes 269C · S.E. Of Malta, IDThe purpose of the flight was for predator (coyote) control. The pilot was following a coyote at a low-altitude, moderate-speed air taxi over snow and sagebrush covered terrain. One of the aircraft's snowboards caught several sagebrush limbs and the pilot…NTSB DCA82AA011Accident · 78 fatalFinal reportBoeing 737-222 · Washington, DCThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-82/08. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Sched…NTSB LAX82DVG13Accident · No injuriesFinal reportSchleicher ASW 20 · Calistoga, CAOn final approach for landing, the pilot retracted the gear when he intended to actuate the spoilers. He landed with the gear retracted and slid into a fence at the end of the runway. The pilot reported that when the gear handle is in the down position, it is…NTSB DEN82FA016Accident · 2 fatalField investigationFinal reportCessna 210 · Helena, MTThe aircraft crashed into a mountain at the 9300 foot level. The pilot was on course for his destination. The minimum obstacle clearance altitude for his location was 10,800 feet. Weather was not a problem but the accident did occur during hours of darkness.…NTSB LAX82FUM06Accident · 3 fatalFinal reportNavion A · Ramona, CAThe accident occurred during the final leg of a "share the expenses" commuting flight from hawthorne to romona, CA, when the aircraft collided with the southwest face of mount woodson. Marginal VFR conditions prevailed over the route of flight. During the…NTSB LAX82FA038Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Near Las Vegas, NVThe aircraft, a Piper PA-34, was on a VFR flight to transport bank checks on a part 135 operation. Another company pilot in a Cessna 207 stated that he encountered instrument conditions at 9500 ft while he was flying from tonopah to las Vegas, NV. The Cessna…NTSB LAX82FA040Accident · 2 fatalField investigationFinal reportGrumman AA-5B · 10 Nm W Lee Vin, CAWhile on the ground the pilot was refused a route over the sierra mountains, after departure the pilot requested and was given a change in his flight plan that cleared him over the mountains. At 1654 the pilot advised oakland center that he was climbing…NTSB LAX82DA035Accident · Minor injuriesFinal reportBellanca 7GCBC · San Clementine, CADuring flight, the pilot observed an area of sloping terrain that appealed to him as a prospective piece of land to purchase. He stated that he got too low and slow with the sun in his eyes as he circled the area. The right wing struck the ground and the…NTSB ATL82DKJ10Accident · No injuriesFinal reportBeech V35B · Tuskegee, ALDuring landing, the pilot put the landing gear and flap handles in the down positions. He heard noises that sounded like both had extended and assumed everything was in place. The pilot was unaware that the landing gear was not down until after touchdown. An…