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 NYC99FA213Accident · 3 fatalField investigationFinal reportCessna 172N · Sussex, NJThe pilot's improper decision to takeoff with a tailwind. Factor's in this accident were the tailwind condition and pressure to depart caused by other airplanes performing successful downwind departures.NTSB FTW99LA238Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103C · San Antonio, TXThe pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.NTSB ANC99LA127Accident · No injuriesLimited investigationFinal reportMaule M-7 · Kotzebue, AKAn in-flight collision with a bird.NTSB LAX99LA284Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B3 · Long Beach, CAThe failure of the pilot to maintain clearance with the fence while landing. A factor was the failure of the helipad to meet the obstacle clearance design criteria specified in FAA Advisory Circular guidance.NTSB NYC99LA211Accident · Serious injuriesLimited investigationFinal reportAeromot AMT-300 · Block Island, RIThe pilot's failure to abort the takeoffNTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.NTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.NTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.NTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…NTSB MIA99FA230Accident · 1 fatalField investigationFinal reportCessna 210L · Tampa, FLThe failure of the pilot to follow procedures and directives established by the operator for his failure to fuel the airplane after landing following the first leg. Contributing to the accident was the total loss of engine power due to fuel exhaustion.…NTSB LAX99TA274Accident · No injuriesFinal reportAir Tractor AT-802A · Elko, NVThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude margin while engaged in fire fighting operations.NTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.NTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.NTSB DEN99FA148Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Newcastle, WYThe pilot's inadequate visual lookout and inadequate altitude/clearance from the transmission wires.NTSB ATL99LA117Accident · No injuriesLimited investigationFinal reportQuicksilver GT-500 · Ormond Beach, FLThe in-flight collision with an object for an undetermined reasons. A factor was the stolen/unauthorized use of the airplane.NTSB CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.NTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.NTSB CHI99FA285Accident · 2 fatalField investigationFinal reportBell 206B · Custer, SDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's inadvertent settling with power.NTSB NYC99FA193Accident · 2 fatalField investigationFinal reportPiper PA28R-180 · Seven Springs, PAThe pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.NTSB CHI99FA284Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Titonka, IAThe low altitude maneuver attempted and altitude/clearance not being maintained by the pilot, which resulted in an impact with a pine tree. A factor to the accident was the pine tree.NTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.NTSB CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.NTSB NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.NTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.NTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.NTSB SEA99LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Middleton, IDThe pilot's failure to maintain clearance from an object. Power lines were a factor.NTSB FTW99LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Sanger, TXThe failure of the pilot-in-command to maintain clearance with the power line.NTSB CHI99FA267Accident · 1 fatalField investigationFinal reportAir Tractor AT502B · Giltner, NEThe pilot's inadequate visual lookout, and his failure to maintain clearance from the guy wire. A factor was the guy wire.NTSB FTW99LA202Accident · No injuriesLimited investigationFinal reportCessna A150M · Alvin, TXThe flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.NTSB NYC99LA182Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Newton, NJThe pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.NTSB CHI99LA248Accident · No injuriesLimited investigationFinal reportRobinson R22 · Spring Green, WIthe pilots failure to maintain clearance with the wire. A factor was the wire.NTSB ATL99LA113Accident · No injuriesLimited investigationFinal reportBeech BE23 · Vidalia, GAPilot's decision to attempt a takeoff from an unsuitable pasture. A factor contributing to the accident consisted of previous damage to the leading edges of the wings.NTSB SEA99LA135Accident · Minor injuriesLimited investigationFinal reportQuicksilver MX II A-HP · Coram, MTThe non-rated pilot's failure to maintain clearance from trees while taking off from a gravel pit. Factors include a downdraft.NTSB ATL99LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Asheboro, NCThe pilot's failure to maintain flying speed that resulted in a stall and the subsequent collision with trees.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.NTSB ATL99LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Panther Burn, MSThe pilot's failure to maintain clearance that resulted in the in-flight collision with trees. A factor was his diverted attention following the failure of the DGPS.NTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.NTSB NYC99LA171Accident · 1 fatalLimited investigationFinal reportGuy Pitts S-1S · Norwalk, OHThe pilot's improper decision to conduct a low level aerobatic maneuver, and his subsequent loss of awareness regarding the location of trees at that level.NTSB CHI99FA223Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Fertile, MNthe inadvertent stall. Factors relating to this accident were the instructor pilot maneuvering the airplane at very low altitude and the trees.NTSB CHI99FA222Accident · 1 fatalField investigationFinal reportCessna 182E · Menominee Falls, WIthe pilots failure to maintain adequate clearance. A factor was the static wire.NTSB SEA99FA104Accident · 1 fatalField investigationFinal reportHarry Tomlinson Coot A · Arlington, WAThe pilot's failure to attain adequate clearance from power transmission lines.NTSB CHI99LA216Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Fisher, MNthe pilot's failure to maintain clearance from the crop during an aerial application spray run.NTSB CHI99LA214Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Timber Lake, SDthe pilots selection of the shorter runway and his failure to abort the takeoff. Factors to the accident were the high density altitude, the fence and the fence posts.NTSB CHI99LA225Accident · No injuriesLimited investigationFinal reportMooney M20J · Harbor Springs, MIthe pilot's inadequate compensation for the wind conditions and his failure to maintain clearance with the trees. Factors associated with the accident were the gusty winds, wind shear, and the trees.NTSB SEA99LA099Accident · Minor injuriesLimited investigationFinal reportWhithington Kitfox 1200 · Caldwell, IDThe pilot's failure to maintain clearance from obstacles along his departure path. Factors include the pilot's incorrect positioning of the flaps prior to takeoff, and a transmission wire and trees along the aircraft's flight path.NTSB FTW99FA176Accident · 2 fatalField investigationFinal reportCessna T210L · Petersburg, TXThe failure of the pilot to maintain obstacle clearance.NTSB LAX99LA229Accident · Serious injuriesLimited investigationFinal reportAerostar Rally RX-7 · Prescott Valley, AZThe pilot's inadequate visual lookout and subsequent failure to maintain adequate clearance with the wires.NTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.