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 LAX85FA131Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Woodside, CAThe plt departed san carlos for a 12 NM x-country to half moon bay, CA, with a return leg to san carlos. It is not know whether or not the flt arrived at half moon bay. The acft crashed in remote mountainous terrain aprx 4 NM west of the Woodside VOR which is…NTSB NYC85FA057Accident · 4 fatalField investigationFinal reportCessna 414 · Sadsburyville, PAAcft was on its rwy 29 apch when it collided with gnd 1 mile from the arpt. A witness saw he acft fly over the arpt to the west between 500 to 1500 ft. witnesses near the accident site saw the acft making abrupt maneuvers at low altitude prior to the…NTSB LAX85FJA01Accident · No injuriesFinal reportEmair MA-1 · Paanilo, HIThe plt initiated his 1st spray pass uphill with about a 5 to 10 kt quartering tail wind. While on the swath run, he noted the airspeed was decaying, so he aborted the pass by turning into the wind. However, this resulted in flying over more rapidly rising…NTSB DEN85LA072Accident · No injuriesLimited investigationFinal reportBeech J35 · Salt Lake City, UTThe pilot was practicing touch and go landings. He stated the landing gear collapsed during landing. Investigation revealed gear door damage (gear intransit) and ldg gear circuit breaker was 'popped.' Post accident exam of the gear system failed to reveal any…NTSB SEA85FA049Accident · 3 fatalField investigationFinal reportCessna 170A · Lopez, WAShortly after departure N3845V joined up with another acft and was flying aprx 200-300 ft AGL in formation. The plt of N3845V then pulled up into what witnesses described as a wing over maneuver after which the acft descended to ground impact. One witness,…NTSB LAX85FA115Accident · 1 fatalField investigationFinal reportBell 205A-1 · Newhall, CAThis helicopter collided with hilly terrain while circling at a low altitude. It was following another helicopter in a clockwise circular pattern at the time, and being filmed for the t.v. series 'air wolf'. One witness observed the helicopter decending in…NTSB ANC85FA095Accident · 1 fatalField investigationFinal reportCessna 207 · Port Alsworth, AKThe pilot continued the air taxi flight into adverse weather conditions and struck a mountain.NTSB FTW85LA096Accident · No injuriesLimited investigationFinal reportBeech V35B · Amarillo, TXDuring takeoff, the cabin door opened & the plt elected to return for a landing. He reported that he was distracted by wind noise & 'nervousness' and failed to assure that the gear was extended. As he flared, the propeller contacted the rwy. The plt added…NTSB ANC85FA036Accident · 1 fatalField investigationFinal reportBell 206BIII · Kenai, AKFlt was being conducted to off shore oil platform. Plt was checked out for off shore operations the day prior to this accident. Plt stated visibility above 500 ft was poor & he maintained 500 ft to stay below a stratus layer. Once over the water the only…NTSB LAX85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beaumont, CAThe acft was on a personal VFR flt to santa barbara, CA, on a dark ovcst night. Marginal VFR conditions with lgt rain prevailed. Gnd witnesses rptd the acft was following the hwy at about 200 ft AGL prior to the accident. The plt rptd he inadvertently began…NTSB CHI85LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Plato Center, ILThe acft experienced a nose gear collapse during landing. The plt stated that while on final apch the acft contacted a 3-4 ft high snowbank near the end of the rwy which resulted in the nose gear collapse. He continued to state the snowbank was difficult to…NTSB ANC85LA033Accident · Serious injuriesLimited investigationFinal reportMaule M6-235 · Trading Bay, AKThe plt-in-command, IA an attempt to avoid a mid-air collision, did not control his airplane sufficiently to avoid a stall. Once in the stall the plt-in-command did not properly recover & the airplane mushed into the ground.NTSB DEN85FTI01Accident · 1 fatalFinal reportPolliwagen 2 Place · Manhattan, MTThe acft crashed in an open flt shortly after takeoff and was destroyed by fire. There were no witnesses to the accident. The plt reportedly stated he needed to depart Manhattan by 0500 MST to arrive in helena before 0600 MST when the ATC twr opened as his…NTSB ATL85FA071Accident · Serious injuriesField investigationFinal reportCessna 172N · Dothan, ALThe plt, who was also an ATC specialist assigned to a fss, crashed short of the rwy during an attempted ILS apch. Whe wx conditions were below apch minimums.NTSB DEN85LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Fargo, NDAccording to the solo student plt, the landing was made in a snow filled ditch aprx 5 ft right of the rwy. The nose gear collapsed and the acft nosed over. The plt and his CFI stated that rwy markings were inadequate.NTSB FTW85FA086Accident · 1 fatalField investigationFinal reportCessna 441 · Marble Falls, TXThe acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…NTSB DEN85LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cody, WYThe student plt had the acft owner's (employer) permission to use the acft for solo practice toward obtaining his private plt certificate. Plt was ranch employee and knew one ranch manager would be looking for sheep, plt diverted from instructor's…NTSB FTW85LA085Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · San Antonio, TXThe plt attempted to extend the landing gear but failed to complete the landing checklist by insuring that the gear were down and locked. The acft landed gear up causing a small post crash fire. The plt had been requested to keep his speed up during the apch.…NTSB LAX85LA079Accident · No injuriesLimited investigationFinal reportBell 47G · Chatsworth, CAThe plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.…NTSB MKC85FA037Accident · 1 fatalField investigationFinal reportAero Commander 690A · Pea Ridge, ARPlt was cleared for vor/dme approach to rogers arpt by fayetteville apch control; fayetteville altimeter setting of 29.85 (confirmed by recorded transcript) furnished. Plt did not read back. During apch, acft impacted trees 25 ft AGL at aprx 1320 ft MSL, 3…NTSB LAX85FA074Accident · 2 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe acft departed on a local primary dual instructional flt at about 1030 hrs. The student was in a pre-solo phase & the lesson was to consist of a review of high airwork. The instructor (CFI) had recently become interested in & was working on aerobatics. At…NTSB ATL85FA055Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burlington, KYAcft ferried VFR by owner. Radios repaired before departure, glide slope receiver found inop. At fuel stop wx was forecast IFR for destination. An IFR instructor was then hired for the remaining flt. Owner showed work order to CFI who incorrectly concluded…NTSB SEA85FA035Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601A · Genoa, NVThe plt had flown from carson city, NV to shreveport, la on 12/10/84 for business. At 1530 on 12/12/84, he departed on aflt to corona,CA with refueling stops at albuquerque, NM & phoenix, AZ. He departed phoenix at 2100, but encountered wx & returned to…NTSB MKC85LA034Accident · No injuriesLimited investigationFinal reportCessna R172K · Almyra, ARCrossing over a road the pilot saw a friend's car and elected to turn around and fly back over the road. During the descending right turn, while looking at the vehicle on the road, the acft flew into the ground.NTSB MIA85LA051Accident · Minor injuriesLimited investigationFinal reportBeech V35B · St. Petersburg, FLPlt received special VFR clearance to enter traffic pattern for landing and was advised to descend to 1600 ft and contact tower for landing. Plt initiated descent, lowering gear to increase descent rate and received landing clearance while manuvering to…NTSB MKC85FA030Accident · 1 fatalField investigationFinal reportCessna 150 · Colby, KSOn a heading of 065 deg the acft impacted in a slightly rising open field in a wings level 15 deg nose down attitude. Investigators found the acft in a landing configuration with the wing flaps fully extended and the throttle secured by the throttle friction…NTSB NYC85LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Prospectville, PAPlt stated he allowed the acft to go low on final approach. Collision with terrain separated the landing gear but plt recovered control as acft rebounded and executed a successful go-around. Plt diverted with escort to nearby military arpt where CFR…NTSB NYC85FHJ01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hastings, NYPlt was occupying rt front seat, pax in left. Plt stated he noted eng oil press gage reading low and, recalling prior emerg lndg on golf course due oil starvation, elected precautionary lndg on golf course. Acft overshot intended approach. Plt initiated…NTSB FTW85FA055Accident · 1 fatalField investigationFinal reportBeech A36 · Waxahachie, TXThe acft was seen by witnesses in a dive from aprx 1000 ft AGL. It appeared to not change attitude nor waiver as it continued toward the grnd. Impact with the grnd occurred with the wings level in aprx 15 deg dive on a hdg of 118 degrees. A mark on the a/s…NTSB FTW85FA054Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Allen, TXThe acft collided with the ground as the plt, who was not current for night/instrument flt, tried to maneuver beneath a low overcast on a dark night. Although seriously injured during the accident sequence, the plt was able to tell rescue workers that he 'was…NTSB MIA85LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Parkland, FLThe plt stated that as he approached the airstrip he flew his pattern low. As he turned base the wind caught the left wing shoving the acft down. He jammed the throttle forward but the acft crashed.NTSB LAX85LA043Accident · No injuriesLimited investigationFinal reportCessna 150M · Ojai, CAWhile simulating emerg procedures the plt added power and began a 180 deg turn to avoid colliding with trees. During the turn the right wing tip struck the rising terrain causing the acft to cartwheel to the ground inverted.NTSB CHI85LA051Accident · No injuriesLimited investigationFinal reportCessna 182H · Terre Haute, INPlt stated he was unable to activate the runway lights by radio so visual cues of arpt bldgs were used to line up with runway. Acft lndg/taxi light was inoperative. Plt did not realize he had undershot the approach turn and was, IN fact, lined up to the left…NTSB LAX85FA042Accident · 2 fatalField investigationFinal reportCessna 172N · Jamul, CAThe certified flt instructor and private rated student pilot departed on a local instrument instructional flight. The aircraft departed at aprx 1715 and at 1750 an ELT signal was reported. The aircraft wreckage was located atop a hill at aprx the 2000 ft…NTSB CHI85LA048Accident · Serious injuriesLimited investigationFinal reportBeech D-45 (T-34) · Bedford, ILThe plt reported that during flt, he proceeded to fly along a river. After a time, he reversed course & began flying along the river in the opposite direction. He said that the flt back was at a lower alt & that the propeller contacted something in the water.…NTSB ATL85LA033Accident · No injuriesLimited investigationFinal reportCessna 182RG · Charleston, SCPilot landed the aircraft with the landing gear in the up position. Examination of the landing gear after the accident revealed no evidence of mechanical malfunction or failure that would have prevented normal gear operation.NTSB MIA85FA029Accident · 2 fatalField investigationFinal reportGates Learjet 24F · St. ThomasWhile executing a night visual approach to runway 9 in visual meteorological conditions the aircraft was allowed to descend; crashing into water 2 miles short of the runway. The pilot was not familiar with the airport and failed to make use of a full…NTSB BFO85FA006Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Waterford, VAThe aircraft was observed flying around the airstrip at dusk. As it passed over the aprx center of the field it was seen to nose over into a steep angle continuing until impact. Investigation revealed no evidence of any mal funtion of the aircraft or the…NTSB MIA85FA022Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Jasper, FLDue to a low fuel state the plt elected to make a precautionary landing on a road. Power lines and poles forced the plt to land in unimproved terrain next to the road. During touch down the left wing struck a dirt bank. Exam of the wreckage revealed that 3…NTSB CHI85LA038Accident · No injuriesLimited investigationFinal reportCessna 310C · Grayslake, ILThe plt reported that the landing was normal but the acft settled to the rwy with the gear up while the selector was in the down position. Post accident examination failed to reveal any malfunction of the retraction/extension assembly.NTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…NTSB DEN85FA026Accident · 1 fatalField investigationFinal reportCessna 340 · Las Vegas, NMThe pilot was carrying illegal cargo (marijuana) in N4001Q. During a low high speed pass at night over an intended landing area,the aircraft struck rising terrain. There was approximately 800 lbs of marijuana on the aircraft.NTSB BFO85FA001Accident · 2 fatalField investigationFinal reportBeech 58 · Hot Springs, VAThe destn arpt was unattended at night & when the plt received his last wx briefing at 0519 CDT, no current wx info was available. During arrival, the acft was vectored for an ILS rwy 24 apch & the plt was advised that current wx info was still not available.…NTSB LAX85FA030Accident · Serious injuriesField investigationFinal reportCessna 150M · Lee Vining, CAThe acft crashed into a mountain during a VFR x-country. The acft was approaching the mountain ridge on the lee side anddid not clear the top of the ridge. The plt said that when he saw the acft was not going to clear the ridge he lowered 10 degrees of flaps…NTSB NYC85LA011Accident · No injuriesLimited investigationFinal reportCessna 206 · Menemsha, MADuring climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water.NTSB CHI85FA020Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bruce, WIThe acft crashed into a heavily wooded area during a x-country personal flight. Witnesses observed the acft circle the lighted football field at atlanta, WI, at an altitude low enough that they feared the acft would hit trees in the vicinity. At this time the…NTSB ATL85FA013Accident · 1 fatalField investigationFinal reportCessna 150L · Douglas, GAThe passenger reported that the former aerial application plt was demonstrating an aerial application maneuver when he entered a steep descent over a lake. The plt delayed the recovery and the passenger, who held a student plt certificate, attempted to level…NTSB ANC85LA006Accident · No injuriesLimited investigationFinal reportBeech 3NM · Selawik, AKMaintaining visual separation with other acft, flying a straight-in apch instead of a conventional pattern, and concern over the landing on a short strip interfered with the plt's habit pattern. The gear was not extended and the gear-up landing resulted.NTSB MIA85LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miles City, FLThe acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using…NTSB LAX85LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Sonoma, CAPlt made inadvertant gear up landing. Plt stated he forgot to lower the gear when his attention was diverted to the cabin door which came open in-flight.