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 DEN03FA087Accident · 2 fatalField investigationFinal reportErcoupe 415D · Los Lunas, NMthe pilot's failure to maintain clearance from the transmission wire. Contributing factors were the high wind, the pilot's decision to make a low-altitude turn onto the crosswind leg, and the power line.NTSB CHI03LA134Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Melville, NDThe pilot's failure to maintain clearance from the wires. The low altitude operation and the wires were contributing factors.NTSB LAX03LA160Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Kahoolawe, HIThe pilot's failure to remove the external load cable before the repositioning flight, which resulted in the cable striking the tail rotor in cruise flight.NTSB NYC03FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bruceton Mills, WVThe pilot's intentional decision to continue visual flight into instrument meteorological conditions, and his failure to maintain obstacle clearance which resulted in the airplane striking a guy wire on the communications antenna. A factor was the fog.NTSB NYC03LA111Accident · Serious injuriesLimited investigationFinal reportVirginia Wright Model B · Midland, VAThe pilot's failure to maintain aircraft control.NTSB FTW03LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's failure to maintain clearance with the transmission wires while maneuvering during an aerial application flight. A contributing factor was the haze restricting the visibility.NTSB CHI03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Blaney Park, MIThe pilot's failure to maintain clearance with the tree line. Factors contributing to this accident were the wind gusts and the trees.NTSB LAX03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Paulden, AZthe pilot's failure to attain and maintain the proper climb airspeed. The high density altitude condition was a factor.NTSB NYC03LA110Accident · No injuriesLimited investigationFinal reportAgusta A109E · Harbor Creek, PAThe pilot's improper preflight inspection, during which he failed to remove a flashlight from the tailboom strake. A factor was the pilot's attention be diverted by a mechanic during the preflight inspection.NTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.NTSB MIA03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Brooksville, FLThe in-flight collision with a Black Vulture resulting in substantial damage.NTSB DEN03TA079Accident · 1 fatalFinal reportMcDonnell Douglas A-4N · Salt Lake City, UTThe lose of engine power during descent due to the in-flight collision with a bird which FOD damaged the engine and subsequently melted the turbine section. A contributing factor was the airplane's malfunctioning ejection seat.NTSB NYC03LA102Accident · No injuriesLimited investigationFinal reportCessna 140 · Suffolk, VAThe pilot's misjudgment of his altitude from the wheat field during the execution of a go-around.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB LAX03LA139Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Corona De Tucso, AZThe pilot's failure to maintain an adequate clearance from obstructions while performing low level passes. The pilot's physical impairment due to a high blood alcohol level was also causal.NTSB NYC03LA087Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Waterford, PAThe pilot's inadequate visual lookout which resulted in the collision with the wire. Factors in the accident were the concealment of the poles by trees, the lack of contrast between the wire and grass field.NTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.NTSB ATL03LA080Accident · 1 fatalLimited investigationFinal reportRans S-12 · West Point, TNThe pilot's failure to maintain adequate obstacle clearance which resulted in the inflight collision with a utility line. A factor was utility lines.NTSB CHI03IA108Incident · No injuriesIncident investigationFinal reportPiper PA-31T1 · Wheeling, ILThe pilot's failure to maintain obstacle clearance and the inadequate glidepath which resulted in a collision with a utility pole. Contributing factors were the lack of experience in the incident airplane by the left seat pilot, the visual illusion of a…NTSB MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…NTSB LAX03LA122Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Avondale, AZThe pilot failed to maintain adequate visual lookout and did not maintain clearance from power lines. The backhoe's location, which caused the pilot to alter his planned flight path, was a factor.NTSB ATL03LA066Accident · Serious injuriesLimited investigationFinal reportDaigneault EAA BI-PLANE · Easley, SCThe pilots failure to maintain clearance while maneuvering on initial climb out resulting in an in-flight collision with a residence.NTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.NTSB FTW03FA114Accident · 1 fatalField investigationFinal reportCessna 182S · Fayetteville, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with trees and terrain. Factors were the low clouds and night conditions.NTSB CHI03LA084Accident · No injuriesLimited investigationFinal reportBell 430 · Highland, MIThe pilot's failure to maintain clearance to the roadway sign. Contributing factors were the failure of the tail rotor gearbox, the roadway sign and the low lighting conditions (night).NTSB DEN03FA045Accident · 3 fatalField investigationFinal reportPiper PA-46-500TP · Albuquerque, NMThe pilot's unstabilized approach and his failure to maintain obstacle clearance. Contributing factors were the dark night light condition, and the static wires.NTSB ATL03FA055Accident · 1 fatalField investigationFinal reportBeech A-36 · Milledgeville, GAThe pilot's improper IFR procedure by which he failed to maintain the minimum descent altitude, and his failure to maintain obstacle clearance. A factor was low the ceiling.NTSB LAX03LA104Accident · No injuriesLimited investigationFinal reportTowner Kit Fox 4 · Glendale, AZthe propeller's separation in-flight as a result of a bird strike.NTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.NTSB LAX03LA096Accident · No injuriesLimited investigationFinal reportCessna 310 · Palmdale, CAThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude. Factors in the accident were the low ceilings and the dusk light illumination.NTSB NYC03LA054Accident · 1 fatalLimited investigationFinal reportCessna 182P · So. Charleston, WVThe pilot's failure to perform a go-around prior to touchdown. Factors in the accident were the rising terrain and tail wind.NTSB LAX03LA095Accident · No injuriesLimited investigationFinal reportAerostar RX-7 · Reno, NVA sudden wind shift that forced the balloon to drift towards an obstruction, and the pilot's inability to perform an evasive maneuver in sufficient time to prevent a collision.NTSB ATL03LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hendersonville, NCThe pilot's failure to maintain directional control and clearence from power lines during a go-around, resulting in an in-flight collision with a powerline.NTSB LAX03LA082Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Middletown, CAThe pilot's failure to attain an adequate takeoff airspeed and failure to abort the takeoff when the lack of acceleration was apparent.NTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.NTSB FTW03LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wildorado, TXThe airplane collided with an animal that wandered onto the runway. A contributing factor was sun glare impairing the pilot's view on final approach.NTSB DEN03LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Logan, NMthe pilot's improper in-flight planning/decision, his failure to accomplish appropriate checklist items during the go-around, and his failure to maintain clearance from the trees and the lamp post. Factors contributing to the accident were the low altitude,…NTSB MIA03LA045Accident · 1 fatalLimited investigationFinal reportBornhofen Twinjet 1500 · Melbourne, FLthe pilot-in-command failed to obtain sufficient altitude to clear obstacles at the approach end of the airport which resulted in an in-flight collision with trees.NTSB LAX03FA072Accident · 1 fatalField investigationFinal reportCirrus Design SR 20 · San Jose, CAThe pilot's failure to maintain the course for the published approach procedure due to his diverted attention. The distraction responsible for the pilot's diverted attention was the erroneous frequency assignment provided by ATC and the resultant task…NTSB ATL03LA037Accident · 1 fatalLimited investigationFinal reportLong 2000 · Brewton, ALThe pilot's improper use of flight controls (cyclic and collective) and failure to maintain rotor RPM while maneuvering that resulted in the separation of the tailboom assembly.NTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…NTSB SEA03FA024Accident · Serious injuriesField investigationFinal reportBombardier DHC-8-401 · Medford, ORThe fracture and spalling of the inner-most pane of the aircraft's port side windshield while on a downwind for a night visual approach due to an imposed load beyond that required for windshield certification (multiple bird strikes). Factors include a dark…NTSB DEN03LA031Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Bountiful, UTthe pilot's failure to maintain clearance from the power lines and his improper in flight planning and decision to maneuver on a go around without noting where the power lines were. Factors contributing to the accident were the pilot's inability to see the…NTSB CHI03LA046Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Ada, MNThe pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.NTSB LAX03FA054Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Dolan Springs, AZthe pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude.NTSB OPS03IA001Incident · No injuriesIncident investigationFinal reportAirbus Industrie 330-301 · AganaThe pilot's initiation of a premature descent that was both below the nominal glideslope and steeper than normal. Contributing to the incident was the air traffic controller's failure to respond to the MSAW warning and issue a safety alert as required by FAA…NTSB CHI03LA040Accident · No injuriesLimited investigationFinal reportCessna 172M · Moline, ILThe pilot's failure to maintain altitude clearance during a base to final turn on approach. Contributing factors to the accident were the night conditions and the trees.NTSB SEA03LA016Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Tekoa, WAThe pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's…NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.NTSB DEN03LA018Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Morrison, COthe pilot not maintaining clearance from the telephone lines during landing. Factors contributing to the accident were the pilot not being able to see the telephone lines, the low altitude, and the dark night.