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 CHI07CA119Accident · No injuriesData collectionFinal reportJohnson-Whittman Tailwind JW9L · Saginaw, MIThe pilot's failure to maintain the proper glidepath and clearance from a fence while on final approach.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.NTSB LAX07LA126Accident · 1 fatalLimited investigationFinal reportArbc 150A · Mecca, CAThe pilot's decision to fly in forecasted unfavorable wind conditions that exceeded the balloon's capabilities.NTSB ATL07FA069Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Andrews, NCThe pilot's misjudgment of distance and altitude during a night approach for landing, resulting in an in flight collision with wires and the ground.NTSB LAX07LA122Accident · 1 fatalLimited investigationFinal reportScottish Bulldog 120 · So Lake Tahoe, CAThe pilot's failure to maintain clearance from objects and the mountainous terrain.NTSB CHI07LA095Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Austin, INThe pilot's improper preflight planning/preparation, and his failure to abort the takeoff. Contributing factors were a tailwind and a short runway.NTSB NYC07CA084Accident · Minor injuriesData collectionFinal reportBell 206B · Lewes, DEThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB ATL07CA053Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Oliver Springs, TNThe pilot's failure to maintain adequate clearance, resulting in an in-flight collision with an airport sign.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.NTSB DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB NYC07CA072Accident · No injuriesData collectionFinal reportSud SE3130 Alouette II · Davenport, VAThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.NTSB ANC07LA022Accident · No injuriesLimited investigationFinal reportHughes 369D · Gustavus, AKThe inadequate clearance from a tranquilized moose while hovering in ground effect, and the operator's inadequate procedures for such operations, which resulted in an in-flight collision with the moose. Factors associated with the accident were the moose, a…NTSB NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.NTSB CHI07FA069Accident · 2 fatalField investigationFinal reportEurocopter France EC120B · Gulf of MexicoThe pilot's inadequate compensation for the gusty wind conditions which resulted in his failure to maintain clearance with the structure extending from the offshore oil platform. Contributing to the accident was the gusty wind condition.NTSB CHI07FA068Accident · Serious injuriesField investigationFinal reportCessna 208B · Alliance, NEThe pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.NTSB ANC07CA017Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · Vero Beach, FLAn in-flight collision with a bird while maneuvering, which resulted in structural damage to the left wing of the airplane.NTSB MIA07CA045Accident · No injuriesData collectionFinal reportCessna 172S · Sanford, FLThe inadvertent inflight collision with a bird resulting in damage to the airplane and the pilot having limited control capability.NTSB LAX07CA094Accident · No injuriesData collectionFinal reportGeneral Balloon AX-6 · San Martin, CAThe pilot's failure to maintain adequate altitude/clearance from power lines.NTSB LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.NTSB DFW07FA051Accident · 2 fatalField investigationFinal reportCessna 182R · Batesville, ARThe pilot's failure to maintain clearance from trees. A contributing factor to the accident was the prevailing low ceilings.NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB DEN07CA043Accident · No injuriesData collectionFinal reportCessna 172N · Cottonwood Fall, KSthe pilot's failure to maintain clearance from the fence. Contributing to the accident was the pilot's inability to properly identify the runway environment, and the improper in-flight decision to initiate a go-around.NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.NTSB CHI07CA075Accident · No injuriesData collectionFinal reportBombardier BD-100-1A10 · Waukegan, ILThe bird strike during initial climb after takeoff from the departure airport.NTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…NTSB LAX07CA053Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mojave, CAthe pilot's failure to maintain adequate clearance from a sign while performing a low altitude maneuver.NTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.NTSB NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.NTSB NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.NTSB NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.NTSB NYC07CA024Accident · No injuriesData collectionFinal reportUtva 66 V-51 · Hilton, NYThe pilot's inadequate visual lookout, which resulted in a collision with a dock during takeoff.NTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.NTSB CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB SEA07CA015Accident · No injuriesData collectionFinal reportCessna 210E · Friday Harbor, WAAn in-flight collision with a bird during takeoff.NTSB ATL07CA011Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Linden, ALThe pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.NTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.NTSB DFW07CA001Accident · Serious injuriesData collectionFinal reportChampion Citabria · Slidell, TXThe pilot's failure to maintain clearance from a parked vehicle.NTSB LAX07TA001Accident · Minor injuriesFinal reportErickson S64E · Ojai, CAThe pilot-in-command's improper remedial action, which resulted in a loss of helicopter control. Contributing factors were the retardant tank and snorkel designs.NTSB LAX06LA292Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Minden, NVThe inadequate pre-takeoff checks by the flightcrew that failed to detect that the spoilers were deployed during the takeoff and initial climb. Also causal was the inadequate supervision of the flight by the flight instructor.NTSB DFW06LA209Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Krum, TXThe CFI's and ATP's inflight decision to land halfway down the runway and the ATP's delayed decision to abort the landing. A factor was the ATP's excessive airspeed on final.NTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.