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 SEA91LA233Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miltonfreewater, ORPilot factor in that the pilot failed to insure there was adequate clearance from obstacles for a safe takeoff. A factor to the accident was: the pilot's poor preflight planning/preparation.NTSB CHI91DTK05Accident · No injuriesFinal reportEagle DW1 · Hurley, SDThe failure of the pilot to maintain a visual lookout.NTSB NYC91LA231Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC/2D · Rangeley, MEImproper takeoff planning by the pilot which resulted in an inflight collision with trees during initial climb. A factor related to the accident was the pilot's decision not to use the full lake surface available for takeoff.NTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.NTSB LAX91LA383Accident · 3 fatalLimited investigationFinal reportCessna 172 · Arroyo Grande, CAThe pilot's failure to maintain a proper altitude, and continued flight into instrument meteorological conditions.NTSB ATL91LA168Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe pilot's failure to maintain adequate clearance from objects while practicing aerial application procedures.NTSB SEA91LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Dixie, IDThe pilot's failure to maintain adequate clearance with tree(s) during the initial climb. Factors contributing to the accident were the high density altitude and downdraft conditions.NTSB ATL91LA167Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Calhoun, GAThe pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.NTSB ANC91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gold King, AKThe pilot's failure to maintain a proper descent rate. Contributing to the accident was the rising terrain and the tailwind condition.NTSB MIA91GA211Accident · 1 fatalFinal reportRobinson R-22 Beta · Lake City, FLThe pilot's failure to maintain a visual lookout due to his diverted attention to observe and enter the location of an illegal marijuana patch into the on board loran unit.NTSB SEA91LA225Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Joseph, ORA deer that ran onto the runway.NTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.NTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.NTSB CHI91LA265Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Mosinee, WIThe pilot's poor preflight planning/preparation, and the selection of unsuitable terrain for takeoff. A related factor was the grassy runway (farm field).NTSB FTW91LA145Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Paulina, LAThe pilot's failure to maintain adequate visual lookout for the wires and his misjudging clearance when he attempted to fly under the wires.NTSB MIA91LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cleveland, MSThe pilot's decision to continue the flight with reduced visual lookout due to a dirty foggy windshield.NTSB FTW91LA146Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Patterson, LAThe pilot's failure to maintain clearance with the electical power line. Factors were the bright sun and chemical residue on the windshield.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB NYC91FA097Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Muncie Valley, PAThe pilot's attempt to maintain visual flight into known instrument meteorological conditions, resulting in a collision with trees. Factors related to the accident were: the pilot's failure to obtain a pre-flight weather briefing and his failure to maintain…NTSB MIA91LA194Accident · Minor injuriesLimited investigationFinal reportSchultz Avid Flyer 502 · O'Brien, FLThe pilot in command's improper planned final approach, which resulted in an in flight collision with an electrical service line, and in flight collision with terrain.NTSB CHI91FA254Accident · 2 fatalField investigationFinal reportCessna 172M · Ottumwa, IAImproper IFR procedure by the pilot by not maintaining the proper minimum descent altitude (mda) until established on the ILS localizer and glidepath.NTSB LAX91LA368Accident · No injuriesLimited investigationFinal reportCessna C-T210N · Modesto, CAThe pilot's failure to maintain the proper alignment over the runway. Factors which contributed to the accident were the pilot's inattentive handling of his aircraft, and the dark, nighttime condition.NTSB LAX91LA345Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Elsinore, CAThe pilot's poor judgement for unwarranted low flying and poor visual lookout.NTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.NTSB ANC91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Willow, AKWas the in-flight collision of the airplane with an object due to the pilot-in-command's lack of an adequate visual lookout. Contributing to the accident was the rough, uneven and narrow condition of the airstrip.NTSB LAX91FA344Accident · 1 fatalField investigationFinal reportCessna 182P · Lovelock, NVFailure of the pilot to maintain sufficient altitude for obstruction clearance, and his inadequate visual scan.NTSB FTW91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Jewett, TXPremature retraction of the flaps near the ground at slow airspeed. A factor was the attempted low pass.NTSB ATL91LA145Accident · No injuriesLimited investigationFinal reportCessna 188B · Monroeville, ALThe pilot's misjudgment of the clearance between the airplane and the electrical transmission wire. A factor was the hazy visibility.NTSB LAX91LA332Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Arizona City, AZFailure of the pilot to maintain an adequate visual outlook to avoid the collision with the power transmission lines. Contributing to the accident was the dark night light conditions that prevailed at the time of the accident.NTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.NTSB FTW91DRG05Accident · 1 fatalFinal reportCessna 188B · Driscoll, TXThe pilot's failure to maintain clearance from the guy wire during the aerial application maneuver.NTSB ATL91LA146Accident · No injuriesLimited investigationFinal reportCessna C172M · Mc Minnville, TNThe failure of the pilot to maintain cleearance from obstacles during the final approach to landing.NTSB FTW91LA132Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Sealy, TXThe pilot's failure to maintain clearance from an object on approach.NTSB MIA91LA191Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Hilliard, FLFailure of the pilot to maintain a proper glidepath during final approach resulting in the inflight collision with trees then the ground.NTSB CHI91DEM07Accident · No injuriesFinal reportCessna 188B · Munger, MIA premature liftoff by the pilot. A factor contributing to this accident was the soft runway surface and a stall/mush.NTSB ATL91LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Boone, NCThe pilot's failure to follow the manufacturer's procedures related to takeoff performance. Factors in the accident were: the high density altitude, the high obstructions, and the pilot's lack of expereince with takeoff operations at high density altitude.NTSB ATL91LA139Accident · No injuriesLimited investigationFinal reportCessna 172P · Sylva, NCThe pilot's improper in-flight planning, and his failure to maintain a proper altitude while maneuvering in the canyon. Factor(s) in this accident were: the mountainous, box canyon conditions, the high density altitude, and the downdraft conditions at the…NTSB SEA91LA182Accident · 2 fatalLimited investigationFinal reportPiper PA-20 · Ione, WAInadequate clearance. A factor to the accident was: poor inflight planning.NTSB NYC91LA183Accident · Serious injuriesLimited investigationFinal reportBeech B90 · Waynesville, OHThe shroud lines from the parachute cutting through the left horizontal stabilizer and deforming the left elevator after the jumper had an uncommanded deployment of his reserve parachute and was pulled from the airplane.NTSB ATL91LA130Accident · 1 fatalLimited investigationFinal reportCessna 188 · Snow Hill, NCInadequate visual lookout by the pilot. Factors to the accident were tree.NTSB NYC91DNC03Accident · 1 fatalFinal reportValentin GMB H Taifun 17E · West Arlington, VTPhysiological incapacitation due to cardiovascular disease which resulted in incapacitation and inflight collision with trees.NTSB LAX91LA319Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Patterson, CAThe pilot-in-command's improper visual lookout in a descent at low altitude, resulting in an in flight collision with wires and subsequent in flight collision with terrain.NTSB FTW91DPG16Accident · No injuriesFinal reportAyres S2R-T34 · Mellwood, ARFailure of the pilot to maintain proper clearance with the power line.NTSB LAX91LA316Accident · 2 fatalLimited investigationFinal reportJurca MJ5 Sirocco · Lake Mathews, CAThe pilot's intentional low altitude flight which resulted in a collision with a power line static cable. Contributing to the accident was inadequate light conditions which reduced the pilot's ability to detect the power line.NTSB CHI91LA219Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Plainfield, ILPilot's failure to attain proper alignment with the runway. A factor related to the accident was the high vegetation/crop in which the landing was made.NTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.NTSB DEN91LA100Accident · Minor injuriesLimited investigationFinal reportAerostar S57-A · Avon, COThe pilot's failure to maintain a visual lookout. A factor was: the pilot's attention being diverted.NTSB CHI91FA216Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Seneca, ILProper glidepath not maintained, and inadequate altitude and visual lookout by the pilot in command.NTSB ATL91LA132Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Social Circle, GAThe airplane collided with the steel pole which supports the windsock while the pilot maneuvered to avoid a collision with a deer on the runway.NTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.