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 LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB CHI07CA250Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Vinton, IAThe pilot failed to maintain clearance from the power line while maneuvering during an aerial application flight. A factor was the power line.NTSB NYC07CA181Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight planning.NTSB NYC07CA179Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's delayed decision to abort the landing, which resulted in an impact with a tree.NTSB CHI07CA244Accident · Minor injuriesData collectionFinal reportBell 206B · Columbia, MOThe pilot's failure to maintain control of the helicopter, which resulted in impact with terrain during takeoff. A factor in the accident was the tall grass.NTSB ANC07CA070Accident · No injuriesData collectionFinal reportBell 206B · Anchorage, AKThe pilot's failure to maintain clearance from a light pole during final approach, which resulted in the helicopter striking the pole.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB NYC07CA184Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe certified flight instructor's delayed remedial action, which resulted in an in-flight collision with trees.NTSB LAX07TA227Accident · 1 fatalFinal reportBell 205 A1++ · Happy Camp, CAthe pilot's failure to maintain clearance with the trees during a long-line operation. Contributing factors were the Forest Service's inadequate communication between crews, failure to properly assess the safety of the intended drop zone, reduced visibility…NTSB CHI07CA230Accident · Minor injuriesData collectionFinal reportGulfstream-Schweizer Gulfstream AM G-164B · Walnut Ridge, ARThe pilot's improper decision to takeoff with a tailwind which resulted in a collision with terrain immediately after liftoff. Factors contributing to the accident were the tailwind and the levee.NTSB MIA07CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26E · Big Flats, NYThe pilot's misjudged distance/altitude during approach resulting in collision with trees and the ground.NTSB LAX07CA224Accident · Minor injuriesData collectionFinal reportCessna 150M · Woodland, CAAn in-flight collision with a bird. A factor in the accident was the deteriorated aircraft performance capability due to the increased drag that made continued flight impossible.NTSB DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB CHI07CA220Accident · Minor injuriesData collectionFinal reportSchweizer G-164B · West Liberty, IAThe pilot's inadvertent encounter with birds immediately after takeoff and the resulting loss of engine power. Contributing factors were the fence and ditch encountered during the overrun.NTSB DFW07CA163Accident · No injuriesData collectionFinal reportCessna 172M · Throckmorton, TXThe pilot's failure to maintain clearance from power transmission lines. A contributing factor was the prevailing dusk illumination.NTSB CHI07CA218Accident · No injuriesData collectionFinal reportCessna 188A · New Hartford, MOThe pilot's failure to maintain clearance from the tree line during the turn between aerial application passes. The low altitude, the downdraft encountered by the pilot, and the trees were contributing factors.NTSB CHI07LA208Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Osceola, INThe pilot's failure to maintain clearance with the trees during the aerial application flight. Factors associated with the accident were the trees and the pilot's lack of experience in flying aerial application flights.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB DFW07CA156Accident · Minor injuriesData collectionFinal reportBell 47G-2A · Mercedes, TXThe pilot's failure to maintain clearance from the power transmission line.NTSB MIA07CA122Accident · Serious injuriesData collectionFinal reportBeech B90 · Louisburg, NCThe failure of the jumper to follow procedures.NTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB CHI07FA187Accident · 2 fatalField investigationFinal reportCessna 500 · Conway, ARThe pilot's failure to fly a stabilized approach and his delayed decision to abort the landing. Contributing to the accident was the standing water on the runway.NTSB CHI07CA188Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Walkerville, ILThe altitude/clearance not maintained by the pilot during the aerial application flight. The corn was a contributing factor.NTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.NTSB SEA07TA181Accident · No injuriesFinal reportMcDonnell Douglas DC 10-10 · Tehachapi, CAThe captain's failure to maintain clearance from trees.NTSB CHI07CA180Accident · Minor injuriesData collectionFinal reportCessna 188B · Wyaconda, MOThe pilot's failure to maintain clearance from the trees. A factor in the accident was the trees.NTSB SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB ANC07CA052Accident · No injuriesData collectionFinal reportCessna 175 · Stoney River, AKThe pilot's failure to maintain altitude/clearance during takeoff-initial climb, which resulted in the airplane colliding with a tree, and an uncontrolled descent.NTSB DFW07CA143Accident · Minor injuriesData collectionFinal reportBell BH206B-3 · Sand Springs, OKThe pilot's failure to maintain clearance with ground obstacles, which resulted in a blade strike. A contributing factor was the low altitude selected by the pilot.NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB NYC07CA137Accident · Minor injuriesData collectionFinal reportPiper PA-28RT-201 · Tinicum, PAThe instrument-rated pilot's failure to maintain runway alignment by instruments after encountering fog during the initial climb. A factor was the foggy weather conditions.NTSB ANC07CA043Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from trees while landing, and his selection of an unsuitable landing site, which resulted in an in-flight collision with a tree and an on-ground encounter with brush.NTSB DFW07CA131Accident · No injuriesData collectionFinal reportGrumman G-164A · Okarche, OKThe pilot's failure to maintain clearance from an unmarked light fixture.NTSB SEA07CA143Accident · No injuriesData collectionFinal reportCalstar 1 Eurocopter BO-105S · Concord, CAThe pilot's failure to maintain clearance from an object during hover. Trees were a factor.NTSB LAX07CA183Accident · No injuriesData collectionFinal reportCessna 210F · Denton, MTThe pilot's decision to abort the landing with insufficient runway available to gurantee obstruction clearance.NTSB ANC07CA042Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's delay in aborting the landing, which resulted in an in-flight collision with trees.NTSB DFW07CA123Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Banquete, TXThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.NTSB ANC07CA039Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain altitude/clearance while maneuvering, which resulted in a collision with trees. A factor contributing to the accident was dusk lighting conditions.NTSB SEA07LA249Accident · 1 fatalLimited investigationFinal reportCessna 177 · Pinecliff, WAThe pilot's failure to maintain clearance from the trees while maneuvering in mountainous terrain. Factors include the mountainous terrain, low ceilings, and trees in the area where the pilot was maneuvering.NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB NYC07CA118Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 · Franconia, NHThe pilot's failure to obtain the proper touchdown point. A factor in the accident was an encounter with an updraft while on approach.NTSB LAX07LA168Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Colusa, CAThe pilot's failure to maintain clearance from wires.NTSB NYC07LA114Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · New Holland, PAUnfavorable winds and terrain during a precautionary landing.NTSB CHI07CA131Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Humphrey, ARThe pilot's failure to maintain sufficient clearance between the airplane and the power lines. A factor was the power lines.NTSB LAX07LA143Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · West Athens, CAthe pilot's descent below the published minimum descent altitude for the instrument approach procedure, which resulted in a collision with wires and terrain. Contributing to the accident were the pilot's lack of recent experience in the accident airplane and…NTSB LAX07LA137Accident · No injuriesLimited investigationFinal reportRiesland Fly Baby 1 · Grand Canyon, AZThe pilot's failure to maintain clearance from a fence during landing.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB CHI07CA110Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Brighton, MIThe student pilot's failure to maintain proper glidepath to the runway. Contributing factors to the accident included the passenger vehicle, the rising embankment, and the airport perimeter fence.