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 NYC93LA018Accident · No injuriesLimited investigationFinal reportFranklin-Sullivan Technologies FS 1 · Littletown, PAInadequate altitude due to an improperly planned approach which resulted in a tree strike on final approach.NTSB ATL93LA006Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Supply, NCThe pilot's inadequate preflight planning, which resulted in his inablilty to attain a proper climb rate during the takeoff. Factors were the runway conditions (soft, rough terrain, wet grass), the perimeter trees, and the tail wind conditions.NTSB NYC93FA005Accident · 3 fatalField investigationFinal reportBeech 35 · New Manchester, WVThe pilot's failure to obtain adequate airspeed and abort the takeoff. The pilot's premature rotation, upsloping runway, and a tailwind are contributing factors.NTSB LAX93LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Three Points, AZThe pilot's poor judgment, intentional buzzing, and poor visual lookout. Contributing to this accident was the pilot's diverted attention.NTSB CHI93DCD01Accident · Serious injuriesFinal reportRichard O. Middlen Glasair III SH-3R · Larchwood, IAThe pilot-in-command's intentional low pass and his inadequate visual lookout.NTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.NTSB NYC93LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Marengo, OHThe pilot's inadequate visual lookout due to sunglare, which resulted in a tree strike on final approach.NTSB ATL93LA002Accident · No injuriesLimited investigationFinal reportBeech E-55 · Chattanooga, TNThe failure of an unknown person to follow proper procedures/directives by operating a radio-controlled model plane in airport traffic pattern airspace.NTSB LAX92LA404Accident · 1 fatalLimited investigationFinal reportLanceair 235 · Hollister, CAThe pilot performing the final segment of a visual approach at too low of an altitude resulting in an inflight collision with a guy wire.NTSB LAX92LA401Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Coachella, CAThe pilot's inadequate visual lookout and his failure to maintain an adequate clearance from the wires.NTSB FTW92FA232Accident · 1 fatalField investigationFinal reportCessna 310R · Idabel, OKThe pilot's descent below the minimum descent altitude. Factors were the pilot's improper IFR procedure, low ceiling, and dark night conditions.NTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB LAX92LA399Accident · No injuriesLimited investigationFinal reportPiper 601P · Bakersfield, CAThe pilot's selection of an inadequate altitude for an intentional low pass. Contributing to the accident was the dusk light conditions, and the pilots improper inflight planning and decision.NTSB SEA92LA206Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Leavenworth, WAThe premature lift off by the pilot. Factors relating to the accident were the soft, rough turf airstrip and the high obstructions at the end of the runway.NTSB NYC92FA185Accident · 1 fatalField investigationFinal reportCessna 150F · Lake Neepaulin, NJAn inflight collision with trees after the pilot failed to outclimb the terrain. Factors related to the accident were the pilot's improper use of the flaps and the pilot's decision to operate the airplane over the maximum allowable gross weight.NTSB LAX92LA384Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 Beta · Colfax, CAThe pilot poor in-flight decision to fly at a low altitude and his inadequate visual look-out. The cable (static wire) contributed to this accident.NTSB CHI92LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Marlette, MIThe pilot-in-command's (CFI) inadequate supervision of the dual student pilot and the dual student's inadvertent application of the brakes.NTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.NTSB SEA92LA202Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Cave Junction, ORThe pilot's poor visual lookout. Factors include a static wire in the area of flight.NTSB LAX92LA379Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Tranquillity, CAThe pilot's improper inflight planning; his failure to attain the proper descent rate; and the excessive descent. Contributing to this accident was the landing gear collapse due to overload.NTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.NTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).NTSB FTW92LA222Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mcgehee, ARThe pilot's failure to maintain clearance.NTSB ANC92LA160Accident · No injuriesLimited investigationFinal reportDale Conover Tundra PUP · Beluga, AKThe inadequate preflight planning/preparation by the pilot. A factor was the pilot misjudged his clearance from the trees.NTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.NTSB ANC92LA150Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sparrevohn, AKPilot exercised poor preflight planning/preparation by taking off with a tailwind component. Factors relating to the accident were: the unfavorable wind in the area and the rising hilly/mountainous terrain in the takeoff path.NTSB NYC92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-46-350 · Sanford, METhe pilot did not follow IFR procedures when he disregarded the decision height limitation and failed to initiate a missed approach which resulted in the airplane striking trees.NTSB FTW92LA219Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ARThe pilot's inadequate visual lookout while maneuvering at low altitude.NTSB FTW92DQG01Accident · Minor injuriesFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's selection of a downwind runway for takeoff. A factor was the tailwind.NTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.NTSB LAX92LA360Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Big Bear, CAThe pilots decision to attempt crossing a ridge line at an altitude insufficient to allow for contingency actions in the event of an encounter with down drafts or turbulence. Factors in the accident were the high density altitude and the flight's encounter…NTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.NTSB MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.NTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.NTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.NTSB LAX92LA350Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Stockton, CAThe pilot's poor inflight planning and visual lookout.NTSB FTW92LA209Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Special Shape · Tyler, TXThe pilot's failure to maintain adequate altitude and clearance from obstacles.NTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.NTSB LAX92GA347Accident · 1 fatalFinal reportHughes 369D · Maxwell, CAThe failure of the pilot to maintain an adequate visual outlook, and failure of the company to provide adequate training. Contributing to the accident was: inadequate company supervision during the operation, and inadequate surveillance by the FAA which…NTSB ATL92LA157Accident · No injuriesLimited investigationFinal reportBeech 23-B24R · Walterboro, SCThe inadequate preflight planning by the pilot in command. Factors were the soft runway, and the high density altitude which existed at the time of the attempted departure.NTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.NTSB ATL92LA156Accident · Serious injuriesLimited investigationFinal reportCessna 441 · Gainesville, GAThe poor inflight decision by the pilot in command in that after a partial loss of power, he shut down the wrong engine, did not follow the emergency checklist, did not raise the flaps, and did not retract the landing gear. A factor in the accident was the…NTSB FTW92FA205Accident · 2 fatalField investigationFinal reportCameron V-77 · Mesquite, TXThe failure of the pilot to maintain clearance from known obstacles.NTSB CHI92FA232Accident · 2 fatalField investigationFinal reportBell 206B · St. Charles, MOThe pilot-in-command's failure to see and avoid the wires, and his physical impairment due to alcohol consumption. A factor which contributed to the effect of the alcohol impairment was the medicine.NTSB ATL92LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Manteo, NCThe delayed level off by the pilot, during the banner pick-up, which resulted in the entanglement of the banner with the horizontal stabilizer.NTSB FTW92DPG13Accident · 1 fatalFinal reportCessna A188 · Forrest City, ARThe pilot's failure to maintain clearance with the trees.NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.