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 SEA92LA124Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Klamath Falls, ORThe pilot's poor inflight planning/decision. Factors to the accident were: clearance was not maintained and inadequate remedial action.NTSB ATL92LA120Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG 300 · Arabi, GAThe pilot's inadequate visual lookout when he failed to see and avoid obstacles. Factors were the loss of thermal lift and the pilot's diverted attention.NTSB ATL92LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Socastee, SCThe failure of the pilot to maintain proper clearance from terrain during the maneuver. Factors in the accident were the failure of the pilot to release the banner, and the excessive size of the banner.NTSB FTW92LA150Accident · 1 fatalLimited investigationFinal reportLewis-Starduster SA300 · Wills Point, TXThe pilot's inadequate visual lookout.NTSB LAX92LA227Accident · No injuriesLimited investigationFinal reportAir Tractor AT 400 · Lemoore, CAThe pilot's failure to observe the presence of an obstacle in the field. Factors which contributed to the accident were the dark nighttime light condition, and the small size and color of the obstacle which decreased the conspicuity of the object.NTSB ATL92LA122Accident · No injuriesLimited investigationFinal reportAirship Industries Airship 600 · Weeksville, NCThe improper installation of the elevator control cables by repair facility maintenance personnel, the inspector's inadequate inspection of the maintenance accomplished, and his failure to follow delineated procedures. An additional cause was the inadequate…NTSB SEA92LA117Accident · No injuriesLimited investigationFinal reportCessna 172L · Yakima, WAThe pilot's failure to maintain the proper descent rate and inadequate remedial action.NTSB SEA92LA112Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Wenatchee, WAThe pilot in command's inadequate visual lookout. Factors contributing to the accident were: object (fence post) and windshield dirty (foggy)NTSB LAX92LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Butte City, CAThe pilot's failure to follow normal procedures by selecting the wrong runway. Contributing to this accident was the pilot's premature lift off and the existing tailwind.NTSB ATL92FA107Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Wetumpka, ALThe pilot's inadequate visual lookout, and his failure to maintain proper clearance from the transmission wires.NTSB SEA92LA108Accident · No injuriesLimited investigationFinal reportCessna A188A · Redmond, ORProper clearance from objects was not maintained. Factors to the accident were: sunglare, wires, and visual lookout was not possible.NTSB CHI92LA155Accident · No injuriesLimited investigationFinal reportCessna 172RG · Dekalb, ILThe pilot not maintaining a proper glidepath to the landing runway.NTSB BFO92LA070Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Morrisville, VTThe pilot's failure to maintain clearance with the terrain. Contributing to the accident was a dark night and the lack of familiarity with the geographic area.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB BFO92FA069Accident · 2 fatalField investigationFinal reportCessna 172P · Princeton, NJThe pilot's failure to maintain clearance over an obstacle. Contributing factors were a tailwind, dark night, and premature raising of the flaps.NTSB DEN92LA053Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COThe pilot did not maintain clearance and the airplane collided with a fence post.NTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.NTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.NTSB BFO92LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Easton, PAThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB ANC92LA071Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Chitina, AKThe pilot's failure to maintain proper alignment with the landing area. Contributing factors were the gusty wind and the trees.NTSB BFO92LA054Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · South Boston, VAThe pilot failed to maintain obstacle clearance which resulted in inflight collision with a powerline.NTSB FTW92LA123Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Bayside, TXThe pilot's inadequate visual lookout.NTSB CHI92DCD03Accident · Minor injuriesFinal reportPiper PA-36-375 · Deloit, IAInadequate visual lookout by the pilot in command while performing aerial application maneuvers. A factor in the accident is the pilot's diverted attention.NTSB CHI92LA134Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · La Crosse, WIVisual lookout inadequate and diverted attention by the pilot. A factor related to the accident was transmission wires crossing flight path.NTSB FTW92LA120Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Madil, OKThe pilot's failure to maintain adequate clearance with the wires. A factor was the existing sunglare.NTSB SEA92FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Shaw Island, WAA delayed go-around, and procedures not being followed. Factors include a lack of total experience in this type of operation, trees near the runway, and an uphill runway slope.NTSB SEA92LA079Accident · No injuriesLimited investigationFinal reportHughes 269C · Silverton, ORInadequate preflight planning and preparation. A factor to the accident was: visual lookout was not maintained.NTSB LAX92LA178Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Galt, CAThe pilot's poor in-flight decision by selecting an improper cruise altitude. Contributing to this accident was the pilot's fatigue due to lack of sleep.NTSB NYC92DEK01Accident · Minor injuriesFinal reportFlight Works Capella · Fredonia, OHAn in Flight collision with telephone wires while on approach for landing.NTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.NTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.NTSB FTW92LA113Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lawton, OKThe pilots'decision to fly into marginal VFR weather. A factor was the guy wire and fog.NTSB MIA92GA107Accident · 2 fatalFinal reportBeech C90 · St. Augustine, FLThe pilot's failure to properly adhere to the published instrument approach procedure which resulted in descent below the minimum descent altitude. Factors which contributed to the accident were the low ceiling and fog.NTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…NTSB NYC92DGT01Accident · Serious injuriesFinal reportSchempp-Hirth Discus BT · Julian, PAThe pilot's inadvertent use of the speed brakes, which resulted in an excessive rate of descent. A factor related to the accident was the pilot's inadequate preflight.NTSB LAX92FA160Accident · 2 fatalField investigationFinal reportCessna 182P · Arcata, CAThe pilot's descent below decision height, and his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the adverse weather conditions and the dark night light conditions.NTSB ATL92LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tifton, GAThe pilot's improper single engine go-around procedure, in that he failed to raise the flaps and landing gear, and failed to maintain minimum control airspeed. A factor was the unfavorable wind conditions.NTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.NTSB CHI92LA114Accident · Minor injuriesLimited investigationFinal reportBellanca 7 Gcbc · Quinn, SDThe pilot's inadequate visual lookout.NTSB SEA92LA056Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Dufur, ORThe pilot in command's misjudgment of clearance with the power lines. Factors contributing to the accident were: object (transmission wire) and safety system (not installed).NTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…NTSB SEA92LA055Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Oxbow, ORFailure of the pilot to maintain a proper visual lookout. A factor in the accident was the pilot's poor judgement in operating at low altitude along the river.NTSB FTW92LA081Accident · No injuriesLimited investigationFinal reportCameron 084 · Maumelle, ARThe pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.NTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.NTSB LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…NTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.NTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.NTSB ANC92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Pelican, AKThe pilot's inadequate visual lookout during takeoff. Contributing to the accident was the glare from the sun.