NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
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\" = 220) 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" = 220) 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 MIA88LA154Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Orlando, FLThe plt stated that the winds started to pick up & he decided to land. During the apch just before touchdown, the gondola struck a tree, causing the occupants to fall against each other, breaking one of the passengers legs.NTSB ATL88FA142Accident · Serious injuriesField investigationFinal reportBalloon Works AX-8B · Alpharetta, GANTSB ATL88LA141Accident · No injuriesLimited investigationFinal reportCessna 170A · Athens, GAThe plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd…NTSB BFO88FA034Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Manassas, VAThe pilot had departed waycross, GA, on the morning of the accident for a cross country flight to Manassas, VA. During the approach into Manassas, the aircraft contacted trees off the approach ends of rwys 34L and 34R. Both rwys were in use at the time and it…NTSB DEN88FA090Accident · 4 fatalField investigationFinal reportBeech A36 · Colorado Spring, COAfter takeoff the acft failed to climb sufficiently to clear a utility pole one-half mile off the end of the runway. The acft collided with the pole and crashed in a residential street. The plt and three pax were fatally injured and the acft was consumed by…NTSB NYC88LA119Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Poland, NYAfter several takeoffs in a southwesterly direction from a farm field, the student pilot attempted a takeoff downwind in an easterly direction and failed to clear the trees at the end of the field. The airplane crashed into the trees and terrain, and was…NTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.NTSB NYC88LA113Accident · No injuriesLimited investigationFinal reportPiper J-3 · Downingtown, PAThe pilot was performing touch and go wheel landings. During an approach the pilot came in too low and the right main landing gear impacted an electric power pole. The pilot landed the aircraft on a grass strip with only the left main gear then flipped…NTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…NTSB LAX88LA133Accident · 1 fatalLimited investigationFinal reportGulfstream American AA5A · Union City, CADuring a pleasure flight, the airplane collided with a power line tower. The airplane was consumed by fire. The weather at the time of the accident was reported to be instrument meteorological conditions with low fog. The pilot did not file an instrument…NTSB SEA88LA066Accident · No injuriesLimited investigationFinal reportCessna 150 · Fox, ORWhile departing an airstrip situated on top of a hill the aircraft was not able to clear power lines at the end of the airstrip. The pilot lowered the nose of the aircraft to clear the wires and the aircraft's elevator struck a road sign in flight. The…NTSB ATL88LA121Accident · No injuriesLimited investigationFinal reportCessna 140 · Easley, SCThe plt rptd that he attempted to land at the 2,000 ft strip in a 15 kt tailwind. The airplane touched down long, and he elected to abort the ldg and takeoff again. During initial climb, he felt the tailwheel hit trees located at the end of the rwy. He…NTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…NTSB LAX88LA131Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Phelan, CANTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…NTSB BFO88FA025Accident · No injuriesField investigationFinal reportCessna 150E · Mitchellville, MDThe student plt elected to initiate the flt even though the flaps malfunctioned during the previous flt. Shortly after takeoff the plt was unable to keep the flaps in the extended position. The plt had not been feeling well on the morning of the flt and felt…NTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.NTSB LAX88FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28R-180 · Soledad, CAPilot's failure to promptly initiate remedial action and his failure to raise the aircraft's landing gear during an attempted go-around. Contributing factors relate to the pilot's poor in-flight decision, inattentiveness to VFR procedures and his not…NTSB MIA88FA114Accident · 2 fatalField investigationFinal reportCessna 172N · Kissimmee, FLThe acft was observed at about 2000 ft sw bound & the sound of the eng could be heard. The acft was next observed about a minute later inbound at about 50 ft & eng sound could be heard. The witness heard a 'poof' sound & the acft was observed inverted. The…NTSB FTW88DPJ03Accident · Serious injuriesFinal reportCessna 172M · Norman, OKPilot retracted flaps during go around and aircraft settled into trees and was destroyed. Front seat occupants were not wearing the available shoulder harnesses. The acft was landing with a quartering tailwind. Due to serious head injuries the plt never…NTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.NTSB LAX88LA111Accident · Serious injuriesLimited investigationFinal reportCessna R182 · San Andreas, CADuring a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not…NTSB DEN88LA077Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Gila, NMThe plt said that he and his friend were on a pleasure flt following a river bed when he spotted some electrical power lines ahead. He said that he felt that he had adequate clearance over the lines but that he did not see the static line above the wires. The…NTSB MIA88LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLWhile on a personal flt, the passenger requested the instructor plt to demonstrate a forced landing. The plt descended, set up for a normal landing, & when the acft was at an alt of aprx 50- 100 ft, discontinued the descent & added power for climbout. At that…NTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…NTSB ATL88LA090Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Birmingham, ALThe airplane collided with trees on a hill at night, while on final approach. The plt rptd that he 'evidently got too low' on the approach. The visibility was 10 miles. The hilly terrain in the vicinity of the accident site was undeveloped, and had no…NTSB NYC88LA079Accident · 1 fatalLimited investigationFinal reportCessna 172P · East Hampton, NYThe flight departed East Hampton airport for a pleasure flt. Shortly thereafter, the pilot called on frequency 122.7 stating that he had struck some birds and could not maintain control of the aircraft. There as no further transmission as to his location, and…NTSB MKC88LA052Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEThe pilot said that he was using outdated charts for his destination apt. He failed to notice a new runway. He also failed to notice the yellow x's, signifying closure of the old runway. It was almost parallel to the runway, within ten degrees of heading. Ldg…NTSB FTW88FA057Accident · Serious injuriesField investigationFinal reportCessna 120 · Ada, OKThe pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.NTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.NTSB SEA88LA043Accident · 2 fatalLimited investigationFinal reportBeech 58P · Ketchikan, AKAcft collided with trees 1400 ft short of rwy during ILS approach. The acft was left of centerline and about 100 ft below glideslope at that time. Witnesses heard sounds of increased power and impact. When the approach clearance was given the wx was 1000 ft…NTSB LAX88LA093Accident · 2 fatalLimited investigationFinal reportCessna TU206G · Kirkland, AZDuring a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.NTSB ATL88LA101Accident · No injuriesLimited investigationFinal reportRockwell 112A · Juliette, GAThe airplane struck a transmission cable over a river at about 100 ft AGL. The plt rptd that he inadvertently stalled the airplane while turning to reverse direction during an aerial photo flt, and that he felt a 'bump' during recovery. After returning to the…NTSB ATL88LA083Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Charlotte, NCDuring the final approach on the instrument landing system, the pilot descended below the glidepath. The aircraft collided with a tree and struck the ground short of the runway threshold.NTSB ATL88FA082Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Augusta, GANTSB FTW88MA048Accident · 1 fatalMajor investigationFinal reportHawker Siddeley 125-600A · Houston, TXBfr tkof, a plt of xa-kut was briefed that the Houston hobby (hou) wx was IFR with '. . . Indefinite ceiling zero sky obscured visibility's 1/16 of a mile and fog . . .' He was also adzd IFR conds were forecast until 0900 CST, gradually improving to marginal…NTSB LAX88LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sun City, AZNTSB LAX88LA083Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G109B · Tehachapi, CAThe pilot and his passenger used the motorglider's powerplant to takeoff and climb to a mountain ridge to soar. Upon reaching the ridge top the pilot shut off the powerplant and entered soaring flight. The passenger stated that the motorglider descended into…NTSB DEN88LA051Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Rio Rancho, NMDuring the landing the plt reported a wind shift which drifted the balloon into pwr lines before the landing could be accomplished. The plt reported she could not see the pwr lines due to the balloon restricting visibility and the pax pointed the lines out to…NTSB MIA88FA083Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Pembroke Park, FLThe non-instrument rated private pilot obtained a weather briefing that indicated the weather would be deteriorating to IMC, but he attempted a flight anyway. During the flight, he became disoriented and penetrated 2 control zones and then struck an antenna…NTSB ATL88FA072Accident · 2 fatalField investigationFinal reportNorth American T-28C · Woodstock, GAA plt/witness rptd that the airplane first flew over the arpt to the North at about 500 ft AGL, and subsequently performed a wingover at the North end of the arpt. The airplane then made a high-speed pass over the rwy to the south, at about 50 ft AGL. Upon…NTSB LAX88DUQ03Accident · Serious injuriesFinal reportRolladen-Schneider LS-3 · Santa Ynez, CADuring a pleasure flight, the left wing of the glider struck a tree and collided with the terrain during a left turn in sinking air. The plt stated that he was looking over his right shoulder at nearby traffic then turned to look forward into the hazy setting…NTSB ATL88FA068Accident · 4 fatalField investigationFinal reportPiper PA-28RT-201 · Rutherfordton, NCThe pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…NTSB MIA88FA071Accident · 1 fatalField investigationFinal reportCessna 150H · Destin, FLWitnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…NTSB MKC88FA032Accident · 2 fatalField investigationFinal reportCessna 402C · Chadron, NEThe acft was on a flt to Chadron via Chadron VOR. Abt 30 mi sse of the VOR, the plt reqd & was clrd to fly drct to ackmeiaf for an NDB rwy 2 apch. The acft contd twd the VOR which was in the same general drctn, but 11.9 mi south of ackme. The NDB was at the…NTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…NTSB FTW88FA039Accident · 15 fatalField investigationFinal reportAerospatiale SA-330J · Eugene IslandThe helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.…NTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…NTSB FTW88LA040Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · Eldorado, TXWhile the pilot was attempting to land in a clearing, the main rotor blades contacted a tree causing the aircraft to descend uncontrolled for about 40 feet. The helicopter struck the ground in a nose low attitude causing damage to the skids, bubble, rotor…NTSB MIA88FA063Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Geneva, ALPrior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…