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 FTW91DRA06Accident · 1 fatalFinal reportMorrison-Keitel VOLKSPLANE-1 · Woodbranch, TXThe airplane's collision with trees for undetermined reasons.NTSB LAX91LA302Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAThe erection of a construction sign on an active runway by county workers without notifying the airport operators, and, the inability of the pilot to detect the presence of the sign during the dark night takeoff.NTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB DEN91FA097Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Denver, COImproper planning/decision by the pilot. Factors related to the accident were: a tail wind, the high density altitude, the pilot's failure to properly lean the mixture, and his failure to use all available runway.NTSB MIA91LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Rontonda West, FLThe failure of the pilot-in-command to maintain an adequate visual lookout which caused him to fly the airplane into wires.NTSB BFO91LA064Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berlin, MDThe unsuitable placement of two banners (improper planning) by other personnel causing an unintentional pickup of both banners.NTSB CHI91LA209Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hill City, SDPoor preflight planning by the pilot and over confidence in the aircrafts ability. Factors related to the accident were a high density altitude and a proper climb rate not attained.NTSB MIA91LA170Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Falcon, MSIn flight encounter with weather, high density altitude. Contributing to the accident was aircraft gross weight which was exceeded.NTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.NTSB FTW91LA103Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Brighton, AR(1) The pilot's failure to maintain adequate clearance from the wires and (2) the wire's subsequent interference with the flight controls.NTSB FTW91LA098Accident · Serious injuriesLimited investigationFinal reportSikorsky S76A · Ship Shoal 290kThe copilot's reduction of power to ground idle on both engines. Factors were the pilot's poor landing technique and his failure to establish adequate crew coordination.NTSB CHI91DER06Accident · No injuriesFinal reportPiper PA-36-285 · Fergus Falls, MNThe pilot's failure to maintain adequate clearance from obstacles during aerial apllication operations.NTSB FTW91LA099Accident · No injuriesLimited investigationFinal reportChampion 7FC · Medina, TXThe pilot's inadequate visual lookout.NTSB ANC91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKThe pilot's failure to use proper takeoff procedures. Contributing to the accident was the tailwind, and the rising terrain.NTSB NYC91DHA02Accident · Minor injuriesFinal reportVans RV-4 · Manville, NJThe pilot's failure to maintain directional control of the airplane after an aborted landing, which resulted in the airplane colliding with a mound of dirt off the runway.NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.NTSB LAX91LA257Accident · 1 fatalLimited investigationFinal reportSchweizer 269B · Cottonwood, CAThe pilot's inadequate visual lookout. The transmission wire was a factor in the accident.NTSB FTW91DRG03Accident · Serious injuriesFinal reportGrumman G-164A · Weslaco, TXFailure of the pilot to maintain clearance.NTSB BFO91DIA01Accident · Serious injuriesFinal reportHagaman Pitts Pitts S · Warrenton, VAThe pilot misjuded altitude and clearance above the terrain. Contributing to the accident was aerobatic maneuver performed at low altitude.NTSB MIA91FA160Accident · 1 fatalField investigationFinal reportPiper PA38-112 · South Port, FLThe pilot in commands failure to maintain a safe altitude resulting in an inflight collision with electrical lines.NTSB CHI91LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pulaski, WIThe pilot's failure to select a proper touchdown point. A factor in the accident was inadequate runway maintenance by airport personnel.NTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB SEA91LA122Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Friday Harbor, WAThe pilot's poor preflight planning/preparation. Contributing to the accident were: the pilot did not maintain a proper clearance from an object, the pilot misjudged the wind conditions, and delayed remedial action.NTSB FTW91FA088Accident · 4 fatalField investigationFinal reportBeech A36 · Lakeview, ARThe pilot's improper visual approach, and his failure to maintain an adequate visual lookout for obstructions. Factors were the unmarked power linesNTSB ATL91LA103Accident · No injuriesLimited investigationFinal reportCessna 150F · Monroe, NCThe pilot's selection of unsuitable terrain for takeoff. The unmowed grass runnway was a related factor.NTSB SEA91LA127Accident · Serious injuriesLimited investigationFinal reportMaxair Ultralight · Toledo, WAThe pilot's inattentiveness. Factors were his performance of a low pass, and a transmission wire in his flight path.NTSB DEN91LA077Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAPremature pull up from an aerial application swath run resulting in a collision with an electrical transmission line.NTSB NYC91FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Shelburne, VTPremature lift-off by the pilot, which resulted in a subsequent stall/mush and collision with trees. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, and the unfavorable wind condition.NTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.NTSB SEA91FA110Accident · 1 fatalField investigationFinal reportBeech 35 · Harrison, IDImproper preflight planning/preparation by the pilot. The terrain condition and the pilot's lack of total experience were related factors.NTSB CHI91FA159Accident · 1 fatalField investigationFinal reportLuscombe 8E · Clinton, MIPhysical impairment of the pilot due to heart attack.NTSB LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…NTSB FTW91FA092Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Parkin, ARFailure of the pilot to maintain adequate clearance from objects.NTSB CHI91DCQ05Accident · No injuriesFinal reportCessna A188B · Mingo, KSFailure of the pilot to maintain a visual lookout while performing aerial application. A factor associated with the accident is soft terrain in the selected landing area.NTSB FTW91DPG05Accident · 1 fatalFinal reportAyres S2R-T34 · Wheatley, ARThe failure of the flagman to follow established procedures.NTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.NTSB LAX91LA186Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Madera, CAFailure of the pilot to maintain adequate clearance from the guy wire.NTSB CHI91LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mccook, NEA poorly planned approach and inadequate visual lookout by the pilot.NTSB SEA91LA088Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Clark Fork, IDThe pilot-in-command's failure to maintain proper altitude in cruise light resulting in an in flight collision with a wire and subsequent forced landing in a river.NTSB LAX91LA179Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Piru, CA1) The pilot failing to maintain visual lookout, and 2) inflight collision with unmarked transmission wires.NTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.NTSB LAX91LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Carefree, AZInadequate supervision by the certified flight instructor (CFI), an inadequate visual lookout by both pilots.NTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.NTSB LAX91FA159Accident · 1 fatalField investigationFinal reportRobinson R22B · Temecula, CAThe failure of the pilot to maintain separation from obstacles (power lines).NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB FTW91LA058Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hobart, OKThe pilot's failure to maintain clearance with known objects.NTSB BFO91LA036Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, MDThe pilot's inadequate visual lookout, which resulted in his failure to see-and-avoid the obstruction (fence post).NTSB NYC91FA095Accident · 2 fatalField investigationFinal reportCessna 120 · Simsbury, CTThe pilot's intentional flight into terrain. Contributing to the accident were psychological conditions.