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 LAX93LA157Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Greenfield, CAThe pilot's failure to maintain an adequate clearance from the power lines while performing an aerial application run.NTSB LAX93FA154Accident · 2 fatalField investigationFinal reportCessna 172M · White Water, CAThe pilot's failure to see and avoid the tower due to drug impairment. Factors which contributed to the accident were: the low altitude and the dawn light condition.NTSB ANC93LA043Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ketchikan, AKThe pilot selected unsuitable terrain for takeoff. A factor in the accident was the building situated at the end of the takeoff site.NTSB CHI93FA103Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Newton, IAVFR flight into IMC conditions. Factors related to the accident were fog, and the pilot's lack of total instrument time.NTSB LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.NTSB MIA93LA076Accident · Minor injuriesLimited investigationFinal reportHuddleston-Bell 47G2 · Rio Grande, PRPoor in-flight planning by the pilot-in-command. Contributing to the accident was the flight's lack of total experience.NTSB MIA93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Blountstown, FLInadequate visual lookout by the pilot resulting in failure to avoid the powerline.NTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.NTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorNTSB MIA93LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Mccoy, FLThe in-flight collision with a large bird.NTSB FTW93LA086Accident · No injuriesLimited investigationFinal reportH. Raymond Busby Mustang II · Arlington, TXThe pilot's failure to attain the proper touchdown point and his delay in initiating the aborted landing. A factor was the wet runway and deteriorated braking actionNTSB LAX93LA114Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Rachael, NVThe pilot poor preflight planning and preparation. The road sign was a factor relating to this accident.NTSB LAX93FA112Accident · 4 fatalField investigationFinal reportCessna 414 · Truckee, CAThe decision of the pilot not to follow instrument flight rule procedures during instrument meteorological conditions and poor preflight planning which resulted in operation of the airplane over the maximum gross weight and reduced performance. Factors in the…NTSB ATL93LA056Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · South Mills, NCThe pilot's failure to maintain adequate clearance from trees during an aerial application maneuver. Factors were the trees adjacent to the wheat field, and the soft terrain.NTSB SEA93LA060Accident · No injuriesLimited investigationFinal reportCessna 206G · Keuterville, IDThe pilot's inadequate visual lookout. Factors include a power line in the vicinity of the airstrip.NTSB DEN93LA026Accident · No injuriesLimited investigationFinal reportRaven RX7 · Durango, COPartial failure of the balloon's burner for undetermined reasons. A factor was: unfavorable wind.NTSB SEA93LA056Accident · No injuriesLimited investigationFinal reportBell 206B3 · Brigham City, UTThe location of unmarked electrical transmission wires over a designated airport taxiway. Factors relating to the accident were the pilot's lack of expectancy to encounter wires above an arpt taxiway, and his diverted attention due to the close proximity of…NTSB FTW93LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · El Dorado, ARThe pilot's failure to maintain clearance. A factor was the dark night.NTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.NTSB LAX93LA092Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Watsonville, CAPilot's poor visual look-out. A factor relating to this accident was that the pilot diverted his attention.NTSB BFO93FA019Accident · 2 fatalField investigationFinal reportHughes 269C · Tonawanda, NYImproper inflight planning/decision by the pilot and his failure to maintain clearance from an obstacle during flight. Factors related to the accident include poor visibility and weather conditions at dusk, and the pilot's excessive airspeed for the…NTSB LAX93LA087Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Folsom, CAThe pilot failing to maintain an adequate visual lookout resulting in the helicopter colliding with electrical transmission wires.NTSB FTW93FA061Accident · 3 fatalField investigationFinal reportBeech C24R · Tulsa, OKThe pilot's disregard of and descent below the published decision height. Factors were his failure to maintain proper glide path and localizer alignment.NTSB MIA93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Tarpon Springs, FLThe pilot's failure to maintain the minumum descent altitude (mda) while on a non-precision instrument approach. Factors which contributed to the accident were: the flight service station (fss) specialist's failure to provide the published notice to airmen…NTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.NTSB LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.NTSB LAX93LA057Accident · 2 fatalLimited investigationFinal reportHughes 369B · Fallbrook, CAThat the pilot misjudged the distance of the high tension wires from the helicopter.NTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.NTSB BFO93LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, NJInadequate supervision by the instructor, and his delay in initiating a go around.NTSB CHI93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Manhattan, ILInadequate compensation for wind conditions by the pilot.NTSB ATL93FA025Accident · 3 fatalField investigationFinal reportCessna 172 · Brownsboro, ALThe pilot failed to evaluate the wind conditions and took off with a tailwind which resulted in the collision with a tree on the departure end of the runway. Factors were dark night and tailwind.NTSB SEA93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vancouver, WAThe pilot's inability to see birds due to darkness.NTSB LAX93LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Mariposa, CAThe pilot's failure to maintain a sufficient airspeed margin while on final approach, and, after encountering a down draft, his failure to correct the resulting descent rate and maintain a glide path which would maintain obstacle clearance.NTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.NTSB SEA93FA020Accident · 1 fatalField investigationFinal reportCessna T210R · Boise, IDProper altitude was not maintained. Factors to the accident were: fog, dark night conditions, and improper IFR procedures.NTSB FTW93FA032Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Uvalde, TXClearance not maintained by pilot in command.NTSB CHI93LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ames, IAThe pilot exceeded the aircraft's maximum gross weight limitation which resulted in the failure to obtain a proper climb rate after takeoff.NTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.NTSB LAX93LA021Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Gonzales, CAThe pilot's failure to maintain adequate clearance from the wires.NTSB ATL93LA019Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Rives, TNThe pilot's failure to follow instrument procedures while conducting an instrument approach which resulted in the collision with trees; the pilot descended below the minimum descent altitude.NTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.NTSB DEN93FA008Accident · 1 fatalField investigationFinal reportCessna 172P · Woody Creek, COAircraft climb performance exceeded. Factors were: the pilot's lack of experience in mountain flying, and the high density altitude conditions.NTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.NTSB FTW93FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Liverpool, TXThe pilot's failure to maintain clearance with the obstruction. Factors were: the pilot's lack of total experience in night operations, and inadequate supervision from the certified flight instructor.NTSB LAX93FA014Accident · Serious injuriesField investigationFinal reportCessna T337G · Fullerton, CAThe pilot's failure to maintain control of the aircraft during a circle to land maneuver in reduced visibility conditions. A factor in the accident was his distraction while reconfiguring the aircraft for a go around which led to an inadvertent entry into a…NTSB FTW93LA016Accident · No injuriesLimited investigationFinal reportVuncannon Rotorway R162 · Wynne, ARLift degradation on one main rotor blade surface due to a foreign object.NTSB NYC93FA015Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Elkton, VAThe pilot's delay in aborting the landing which resulted in insufficient runway remaining to allow the airplane to reach sufficient altitude to clear the obstacles at the end of the runwayNTSB NYC93LA016Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Kitts Hill, OHA hard landing due to improper use of the collective, following a wire strike due to inadequate visual lookout.NTSB LAX93FA007Accident · 1 fatalField investigationFinal reportCessna 172M · Fairfield, CAThe pilot's delay in initiating a go-around during a night landing. Factors related to the accident were: the pilot misjudging distance and speed resulting a overshooting the touchdown, the night light condition, his lack of night flying experience in a…