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 CHI02LA219Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Abilene, KSThe pilot failed to achieve clearance over the trees and wires. Factors associated with the accident were the pilot failed to use all available runway, a downwind takeoff was performed, the tailwind, trees, and wires.NTSB DCA02MA054Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 727-232 · Tallahassee, FLThe captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…NTSB FTW02LA217Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Eugene Is 192The loss of tail rotor control due to an in-flight collision with an object.NTSB CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.NTSB LAX02FA234Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kneeland, CAThe pilot's failure to maintain clearance with the trees while executing an instrument approach. Contributing factors were the clouds and obscuration weather conditions.NTSB LAX02LA232Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Knights Landing, CAThe pilot's inadequate visual lookout, resulting in an in-flight collision with wires.NTSB CHI02CA201Accident · Minor injuriesData collectionFinal reportSchweizer 1-26B · New Douglas, ILThe probable cause of this accident was a failure to maintain the proper glide path and sufficient obstacle clearance while on final approach.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…NTSB ANC02TA077Accident · No injuriesFinal reportBell 212 · Wasilla, AKThe pilot's selection of an unsuitable landing site, and failure to maintain clearance with trees, which resulted in the main rotor blade striking a tree.NTSB ANC02LA079Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Toksook Bay, AKA bird strike during takeoff, which resulted in damage to the right wing.NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.NTSB SEA02LA122Accident · No injuriesLimited investigationFinal reportHead Balloons AX8-88 · Victor, IDThe pilot's failure to maintain altitude/clearance from the power lines during the landing resulting in the balloon's impacting the wires. Contributing factors were the power lines and strong winds existent at the time.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB CHI02LA156Accident · No injuriesLimited investigationFinal reportHale Kitfox Model III · Fairmont, MNFailure by the pilot to obtain adequate clearance from the tree line, as well as a failure to abort the takeoff in a timely manner. A contributing factor was the tree line.NTSB SEA02LA128Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · Heron, MTThe pilot's failure to maintain vertical clearance from trees. Factors include tall trees just off the approach end of the runway.NTSB MIA02LA127Accident · 2 fatalLimited investigationFinal reportThomas Outback · Edenton, NCThe pilot/owner's failure to establish an adequate climb rate and his failure to maintain obstacle clearance.NTSB DEN02FA065Accident · 2 fatalField investigationFinal reportBell 206BIII · Raton, NMThe pilot's failure to maintain clearance of the static wire. Factors were the static wire, and the glaring sunlight condition.NTSB ATL02LA128Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A · La Belle, FLThe pilot's failure to maintain visual lookout while maneuvering during an aerial application, which resulted in an in-flight collision with power lines and uncontrolled descent into terrain.NTSB LAX02LA208Accident · Serious injuriesLimited investigationFinal reportWSK PZL Swidnik PW-5 · Loch Lomand, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during final approach. A contributing factor was the windshear and turbulence encountered during the approach.NTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.NTSB ANC02LA059Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wasilla, AKThe unqualified pilot's selection of an unsuitable landing site which resulted in an in-flight collision with a power line. Factors associated with the accident are the unqualified pilot's failure to see and avoid a power line, an unmarked power line, and…NTSB LAX02LA203Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Westmorland, CAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the dark night condition.NTSB CHI02LA165Accident · No injuriesLimited investigationFinal reportFirm Kit Fox 4-1200 · Virginia, MNAn in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.NTSB FTW02LA180Accident · Serious injuriesLimited investigationFinal reportFrennance Twinstar · Bastrop, LAthe pilot's failure to maintain altitude for an undetermined reason, which resulted in an in-flight collision with trees.NTSB NYC02LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Gettysburg, PAThe pilot's failure to accurately compute takeoff performance and his failure to establish a positive climb resulting in a collision with trees.NTSB FTW02LA176Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Dover, ARThe pilot's failure to maintain clearance with trees during the approach. A contributing factor was dark night light conditions.NTSB CHI02LA160Accident · Minor injuriesLimited investigationFinal reportNavion Navion A · Forest Lake, MNThe pilot not performing an aborted takeoff. The soft turf runway and power lines were contributing factors.NTSB CHI02LA157Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Fishers, INThe pilot not performing a go-around prior to exceeding the proper touchdown point and the pilot not maintaining altitude/clearance from the trees. Factors to the accident were the pilot's inadequate preflight planning and the trees.NTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.NTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.NTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…NTSB CHI02LA146Accident · No injuriesLimited investigationFinal reportCessna 182J · Galesville, WIThe pilot failed to maintain clearance with the wires while on final approach. Factors associated with the accident were the low altitude, the downdraft, and the wires which the airplane contacted.NTSB SEA02LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carey, IDThe pilot's failure to maintain clearance from trees during takeoff.NTSB FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.NTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.NTSB LAX02FA173Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Mammoth Lakes, CAThe pilot's poor decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were rising mountainous terrain, the high density altitude, and the exceeded weight and…NTSB ATL02LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Marion, ALThe pilot's failure to maintain visual lookout while conducting an aerial application maneuver. A factor was the transmission line.NTSB LAX02LA169Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Stockton, CAThe pilot's failure to maintain an adequate clearance from the water tower during takeoff. Also causal was the pilot's selection of a confined area for the landing and subsequent takeoff.NTSB IAD02FA052Accident · 1 fatalField investigationFinal reportAyres S-2R · Swanton, MDThe pilot's failure to maintain visual separation from a set of known, yet unmarked power lines.NTSB ANC02TA035Accident · No injuriesFinal reportRobinson R-44 · Cantwell, AKA failure of the pilot-in-command to maintain adequate main rotor rpm during an out-of-ground-effect hover.NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB NYC02LA090Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Blairstown, NJThe pilot's improper flare, and his failure to maintain obstacle clearance which resulted in a tail strike.NTSB ATL02LA094Accident · No injuriesLimited investigationFinal reportBell 47G-5A · La Belle, FLThe pilot's failure to maintain clearance of a tree while maneuvering, which resulted in an in-flight collision with the tree and subsequent uncontrolled descent and collision with terrain.NTSB MIA02LA086Accident · Serious injuriesLimited investigationFinal reportLett R/Campbell K Aircam · Troy, ALthe pilot-in-commands decision to fly at a low altitude and his improper visual lookout resulting in an in-flight collision static with wires.NTSB MIA02LA085Accident · 1 fatalLimited investigationFinal reportGrote Cruiser TR-4 · Pembroke Pines, FLthe pilot-in-command delayed initiating a go-around and failed to obtain sufficient altitude to clear obstacles at the departure end of the airport which resulted in an in-flight collision with power lines.NTSB NYC02LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clifford, PAThe pilot's failure to maintain a proper visual lookout for trees. A factor was sunglare.NTSB NYC02LA083Accident · No injuriesLimited investigationFinal reportBell 206-L3 · New York, NYThe pilot's improper flare while landing, which resulted in a collision with a concrete curb.NTSB IAD02FA043Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, CTThe pilot's failure to follow the published instrument approach procedure. Factors were the night and low ceiling conditions.