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 LAX88FA240Accident · 1 fatalField investigationFinal reportCessna 172P · Descanso, CAPilot's poor judgment and intentional decision to low fly the aircraft below the minimum safe altitude.NTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.NTSB LAX88LA236Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Lake Tahoe, CADuring the initial climb the pilot was unable to sustain a positive climb rate. The acft collided with a tree at the end of the runway and, subsequently, the ground. There were no reported mechanical failures or malfunctions. The density altitude was about…NTSB BFO88LA059Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talcott, WVAccording to a witness, the acft was maneuvering at a low altitude when it contacted trees. The acft then descended, impacting the terrain 45 ft from the trees and slid aprx 110 ft before coming to rest. The plt stated that due to injuries he is unable to…NTSB LAX88LA232Accident · No injuriesLimited investigationFinal reportBeech B35 · Weaverville, CANTSB FTW88LA124Accident · No injuriesLimited investigationFinal reportMooney M20J · Portland, TXThe pilot dragged the lower empennage on the runway during the takeoff rotation. A premature liftoff resulted and the aircraft recontacted the runway twice before the aircraft passed the runway end. Thereafter, the aircraft collided with a powerline before…NTSB BFO88LA058Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Moundsville, WVThe helicopter contacted power lines shortly after takeoff from a mine site. The nose gear of the helicopter contacted an uninsulated static wire. This wire was strung with one other static wire and two black insulated power lines. Both crew members stated…NTSB ATL88FA199Accident · 1 fatalField investigationFinal reportLuscombe 8A · Horse Shoe, NCA witness reported that he was irrigating a newly cultivated corn field with a spray irrigation machine. He heard and then observed the accident airplane fly through or just over a gap in the trees at the northeast end of the field. The airplane proceeded to…NTSB MIA88LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Coldwater, MSThe physician student plt made 3 attempts to land in this short unimproved field. On the 3rd pass, he collided with trees at the end of the rwy while attempting a go-around. The student plt did not have his cfi's permission to land there nor had he received…NTSB NYC88LA169Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Copake Falls, NYDuring a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation…NTSB DEN88LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ayr, NDNTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…NTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…NTSB MKC88LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Dighton, KSDuring an aerial application operation, the plt said that as he initiated liftoff, the acft turned to the left and he felt he had no rudder control. He hit a fence on the apt boundary, continued, dumped his chemical load, hit a tree, and landed in a field…NTSB FTW88LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mounds, OKThe instructor was demonstrating an engine out emergency to the student. The engine balked on the attempted go-around and he completed the landing. Thereafter, his first two takeoff attempts were aborted because of insufficient distance to complete the…NTSB DEN88DTM02Accident · No injuriesFinal reportEagle DW-1 · Enterprise, UTThe plt reported that he had been going under a powerline that ran across the fld being treated. On the acdt pass he lost sight of the powerline and pulled up into the line. The visibility was unrestricted and the pass was being made north to south at mid…NTSB LAX88LA217Accident · 1 fatalLimited investigationFinal reportCessna 150F · Quartzsite, AZNTSB FTW88FA115Accident · 2 fatalField investigationFinal reportCessna 340 · Georgetown, TXThe pilot in the right seat had hired the pilot in the left seat to ferry the airplane to germany, then to turkey. A four tank ferry fuel system was installed but a weight and balance check was not made. During the tkof, the acft would not climb. Afterward…NTSB MKC88LA108Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Wynne, ARFollowing the takeoff from a private strip near Wynne, Arkansas, the pilot reported that he failed to establish and maintain an adequate angle of climb with the heavily loaded condition of the aircraft. The aircraft impacted trees in the flight path, then…NTSB LAX88LA214Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Bakersfield, CAWhile on an instructional flt, the CFI instructed the student to fly above the power line poles at all times. While in cruise flight the instructor was looking away when the helicopter collided with power lines. The instructor took control of the helicopter…NTSB LAX88DVM02Accident · Minor injuriesFinal reportBell 47G5 · Oceano, CANTSB DEN88LA123Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Encampment, WYThe plt stated he calculated the density altitude to have been 11,300 ft at takeoff. He said the acft was near max gross wt and that the grass strip he departed from was approx 1,500 ft long. The plt stated 'I was on the on the back side of the pwr curve as…NTSB SEA88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Hawthorne, NVDuring a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…NTSB MKC88DCQ03Accident · Serious injuriesFinal reportAeronca 11AC · Ada, KSThe a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot…NTSB SEA88LA101Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lester State, WAThe pilot inadvertently flew into a narrow valley with trees on both sides and steep rising terrain during climb to cruise. The aircraft was not able to outclimb the rising terrain, so the pilot slowed the aircraft to 40 m.p.h. and attempted a shallow…NTSB NYC88DGT02Accident · Minor injuriesFinal reportBell 47G3B1 · Cove Gap, PAThe helicopter plt was taking off from an area surrounded by trees & buildings for a local spray operation. The wind was calm. Reportedly, during the attempted departure, the plt 'exhausted all power available then made right turn to return to field.' After…NTSB FTW88LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXThe instructor was simulating an engine-out emergency for the dual student. The student was making an approach to an emergency field with a line of trees on the approach end. When the instructor became aware that they might not reach the field, he directed…NTSB BFO88LA052Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Milford, DEThe plt stated the landing apch was too fast and the acft bounced on touchdown. The plt stabilized the acft and attempted another touchdown, however, the acft bounced again. Having used over half the rwy by this time, the plt elected to abort the landing by…NTSB BFO88FA051Accident · 2 fatalField investigationFinal reportCessna 150F · Petersburg, VAThe plt was being accompanied by a 182 during the flt from NC to tangier island. Both acft landed at Petersburg. A passenger in the 182 had become ill. After refueling and spending a short time at Petersburg, both acft departed for tangier island with the…NTSB ATL88LA187Accident · No injuriesLimited investigationFinal reportCessna 150F · Mc Kenzie, ALThe plt reported that he attempted to takeoff from a pasture that was 'too short'. The airplane began to settle shortly after t/o and one of the MLG wheels struck a short post in the pasture. The airplane hdg was altered and the airplane crashed into a fence.…NTSB LAX88LA199Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Scottsdale, AZWhile on final approach, the acft began to drift to the left. The plt applied rudder control, however, the acft continued to drift off centerline. The plt initiated a go-around; however, during the climb, the landing gear caught on the arpt boundary fence.…NTSB BFO88DIG03Accident · Serious injuriesFinal reportGrumman G-164A · Sleepy Creek, MDDuring the aerial application flight the airplane struck and severed three power lines. The pilot stated he did not see the lines until it was too late. The airplane caught fire and continued on its flight path crossing a highway and a river. The airplane…NTSB MIA88FA179Accident · 1 fatalField investigationFinal reportCessna 172K · Lake City, FLThe acft, while on a local flight, struck a telephone transmission line on the approach end of runway 1. Witnesses stated that they saw the acft takeoff to the west and make a right turn and go out of sight. Aprx three to five minutes later, they heard the…NTSB FTW88DRA12Accident · Minor injuriesFinal reportGrumman G-164A · Winnie, TXAcft was substantially damaged when it struck a ditch and flipped over after settling to the ground following t/o from a pvt ag strip. The plt stated that during the t/o, the wind shifted to a quartering tailwind and that he attempted to dump his load because…NTSB MKC88LA092Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Mc Dougal, ARThe pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades…NTSB FTW88DRD04Accident · Minor injuriesFinal reportGrumman G-164A · Rayne, LAThe pilot had made seven previous takeoffs in that airplane, that day, on the same airstrip. On this one, the OAT was 93 degrees f. the elevation was 10 feet MSL and the density altitude was 2300 feet. The airplane was 388 pounds overweight and the CG was .5…NTSB LAX88FA187Accident · 2 fatalField investigationFinal reportCessna 182A · Grand Canyon, AZPilots selection of an inappropriate cruise altitude which did not ensure adequte terrain clearance on the leg of the flight from page to Grand Canyon, Arizona. A factor in the accident was the pilot's flight schedule on the day of the accident which may have…NTSB ATL88DMG06Accident · No injuriesFinal reportCessna 188 · Messic, NCDuring turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years.NTSB SEA88LA097Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Chemult, ORThe pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to…NTSB BFO88FA047Accident · Minor injuriesField investigationFinal reportCessna 310L · New Cumberland, WVThe plt was doing low passes down rwy 04 when according to the plt he struck a large bird after the second pass just when he was starting to climb about one-half mile from the rwy end. The plt said that the bird shattered the windscreen causing the plt facial…NTSB MKC88DCJ01Accident · Serious injuriesFinal reportCessna A188B · Dalton, NEThe pilot was spraying a large field which had a power line along the north side. On the 1st couple of passes, the spray equipment had intermittent malfunctions. As the aircraft approached the field from north for the 4th pass, it struck the upper cable of…NTSB FTW88DRD02Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant.NTSB MKC88FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Mansfield, MOA witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power…NTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.NTSB FTW88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Pawnee, OKAircraft's flight envelope was exceeded.NTSB NYC88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blairstown, NJThe flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…NTSB MKC88DCQ02Accident · 1 fatalFinal reportPiper PA-25-150 · Chase, KSWitnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover.NTSB NYC88FA131Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Thomasville, PADue to the pilot's improper preflight planning, he attempted to takeoff with his aircraft weight above the maximum gross weight in a high unfavorable 90 degree crosswind, failed to maintain directional control, and collided with trees.NTSB ATL88LA151Accident · Serious injuriesLimited investigationFinal reportCirrus Design Standard · Chester, SCThe glider pilot failed to maintain sufficient altitude while on final approach for landing and struck trees.NTSB DEN88FA099Accident · 2 fatalField investigationFinal reportBeech A23-19 · Gunnison, COOn a cross country flt, the plt attempted to climb through a pass which was above the effective service ceiling of the acft. At approximately the effective service ceiling of the acft the acft collided with terrain. The acft was destroyed by impact and post…