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 NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.NTSB FTW95LA041Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Johnson City, TXThe pilot's failure to maintain clearance with the trailer while landing.NTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.NTSB CHI95LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Tomahawk, WIthe collision with deer during landing - flare/touchdown.NTSB LAX95LA032Accident · Serious injuriesLimited investigationFinal reportBeech 65-90 · San Diego, CAthe inadvertent and premature deployment of the jumper's reserve parachute as he exited the aircraft.NTSB MIA95FA018Accident · 2 fatalField investigationFinal reportBölkow BO-105S · Perry, FLFailure of the pilot to maintain sufficient clearance from the power line, while buzzing (at low altitude).NTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.NTSB LAX95LA030Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · Willits, CAthat the pilot misjudged the distance between the helicopter and the trees.NTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.NTSB LAX95FA020Accident · 2 fatalField investigationFinal reportCessna T337H · Douglas City, CAThe improper in-flight decision of the pilot to fly in dark night time conditions in mountainous terrain during adverse weather conditions.NTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.NTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.NTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.NTSB CHI95LA016Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Ft. Wayne, INthe in-flight collision with birds(geese). A factors associated with the accident was the building which was contacted.NTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.NTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.NTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.NTSB FTW95LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Livingston, TXThe improper flare resulting in an undershoot of the intended landing area. A factor was the bird strike.NTSB BFO95FA001Accident · 1 fatalField investigationFinal reportCessna 172N · Fancy Gap, VAThe pilot's inadequate inflight planning and his failure to maintain adequate terrain clearance. Other related factors are: fog, rain, VFR flight into IMC, inexperience and mountainous terrain.NTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.NTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.NTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.NTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.NTSB LAX94LA379Accident · No injuriesLimited investigationFinal reportRockwell S2R · Visalia, CAthe pilot failed to maintain an adequate visual lookout and collided with power lines which resulted in an in-flight loss of control and subsequent collision with terrain.NTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.NTSB ANC94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's failure to maintain a positive rate of climb.NTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.NTSB MIA94LA210Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLThe pilot's failure to see and avoid the banner.NTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.NTSB NYC94LA171Accident · Serious injuriesLimited investigationFinal reportCessna 152-II · Enfield, NYThe pilot-in-command's attempt to take off under conditions beyond the performance capabilities of the airplane.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB LAX94LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rescue, CAThe pilot's delayed go-around. His inadequate compensation for the wind was a factor.NTSB CHI94LA289Accident · No injuriesLimited investigationFinal reportCessna 172 · Plato Center, ILThe pilot's attempt to take off on a short runway with a gross weight which exceeded the maximum allowable weight and an improper flap setting. A factor was the location of obstructions (trees) at the departure end of the runway.NTSB BFO94LA153Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Wolfeboro, NHThe pilot's failure to maintain directional control during landing which resulted in inflight collission with trees.NTSB ATL94LA160Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Pine Mountain, GAThe pilot's inadequate compensation for existing wind conditions, and his failure to maintain both airspeed and clearance from a fence. Factors were the tailwind and the gusts which existed at the time of the accident.NTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB ANC94LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's inadequate preflight planning and preparation.NTSB NYC94FA161Accident · 1 fatalField investigationFinal reportRockwell 112A · Binghamton, NYThe pilot inadequate preflight preparation that resulted in the decision to attempt takeoff on a runway which was beyond the airplane takeoff performance capability to clear obstacles.NTSB ANC94LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's inadequate in-flight planning and failure to attain a touchdown point in the landing area. An obstacle (tree) in the landing area was a factor in the accident.NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.NTSB LAX94LA326Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Chinle, AZthe pilot's premature liftoff, and his failure to attain the appropriate airspeed during a takeoff attempt under high density altitude conditions.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.