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 FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.NTSB MIA89GA144Accident · 2 fatalFinal reportDouglas C-47 · Summerland Key, FLThe failure of the pilot-in-command to assure proper altitude and clearance was maintained above the terrain and trees. The trees and light condition at dusk were contributing factors.NTSB SEA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gerlach, NVA delay by the pilot in aborting the landing and his failure to assure sufficient airspeed for the go-around (aborted landing). A factor related to the accident was: the unsuitable landing area that was selected by the pilot.NTSB LAX89LA175Accident · No injuriesLimited investigationFinal reportMooney M20E · Julian, CAThe inadequate preflight planning/preparation by the pilot. Contributing to the accident was the loose gravel runway and the fence which the airplane was unable to clear.NTSB FTW89LA085Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Jasper, TXThe pilot's misjudgement of his altitude. Factors related to the accident were: light conditions at dawn and ground fog in the area, which resulted in the pilot's lack of visual perception.NTSB ATL89LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Jacksonville, NCThe pilot's failure to properly preflight and plan which resulted in a collision with trees. The pilot attempted a takeoff with an over gross weight condition.NTSB CHI89DEE02Accident · Minor injuriesFinal reportAeronca 7AC · Marseilles, ILPic's overconfidence in the accident aircraft's climb performance as he attempted to take off up hill and over wires.NTSB ATL89LA136Accident · No injuriesLimited investigationFinal reportCessna 170 · Orwell, OHThe pilot's decision to takeoff on unsuitable terrain, which resulted in his inability to attain sufficient airspeed to clear the fence(s) near the end of the runway. Factors related to the accident were: the soft runway/terrain conditions & the fence.NTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.NTSB ATL89LA135Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Brooks, GAClimb not possible because of a downdraft which exceeded the performance capabilities of the airplane. Factors related to the accident were: inadequate location of the wind sock, the adverse wind conditions, and the trees.NTSB LAX89FA165Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Stockton, CAPoor judgement of the pilot by flying while physically impaired from consumption of alcohol & drugs, and his failure to maintain proper altitude. The light condition (at night) and the obstructions (power lines and building) were considered to be contributing…NTSB MIA89LA133Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Miami, FLThe unqualified persons failure to maintain clearance from the fence. Pressure induced by others, lack of experience, and over confidence in personal ability are contributing factors to this accident.NTSB FTW89FA081Accident · Serious injuriesField investigationFinal reportHead Balloons AX8-88 · Troy, TXImproper planning/decision by the pilot, and inadequate supervision by the check pilot, which resulted in their failure to maintain clearance from the tree during the landing. Factors related to the accident were: the high wind & tree(s).NTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.NTSB SEA89LA086Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355-F2 · Las Vegas, NVThe pilot's poor inflight decision in selecting an unsuitable area for practice landings and the pilot's inadequate visual lookout resulting in a tail rotor strike and loss of antitorque control.NTSB DEN89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Milbank, SDFailure by the pilot to assure adequate removal of frost from the aircraft which resulted in a stall/mush.NTSB NYC89GA116Accident · 2 fatalFinal reportBell 206B · Airville, PAThe pilot was unable to see and avoid the unmarked power lines stretched across the river. A contributing factor was the lack of visual clues.NTSB FTW89FA078Accident · Serious injuriesField investigationFinal reportMBB BK-117A-4 · Houston, TXFailure of the pilot to maintain clearance from the obstruction (garage). Factors related to the accident were: darkness, adverse weather conditions, personnel in the area of the temporary heliport, lack of security provided by hospital management, which…NTSB BFO89LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Odenton, MDThe inflight collision with birds.NTSB LAX89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mesa, AZInadequate visual lookout by the pilot, and his failure to maintain the proper altitude. Factors related to the accident were: the pilot's lack of visual perception at dusk, the transmission line, and the obstructions (tree & fence) in the emergency landing…NTSB ATL89FA116Accident · 2 fatalField investigationFinal reportMBB BK-117-A-3 · Coinjock, NCFailure of the cellular company to properly install an operational lighting system on a newly constructed transmission tower. Darkness and the company's failure to notify flight service of the unlighted tower were related factors.NTSB ATL89LA115Accident · No injuriesLimited investigationFinal reportBeech B24R · New Carlisle, OHThe pilot's failure to clear the trees after the in-flight collision with an undetermined object. He allowed the altitude to decrease to the point of colliding with trees before initiating remedial action to maintain flight and land the airplane.NTSB MKC89LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Advance, MOThe pilot's inadequate visual lookout resulting in his failure to see power lines in time to avoid them. Contributing to the accident was the reduced visibility due to fog.NTSB MIA89FA113Accident · 1 fatalField investigationFinal reportPiper Aerostar 600 · Jacksonville, FLImproper use of the IFR procedure by the pilot, his failure to maintain a proper glide path, and his failure to identify the decision height.NTSB FTW89IA070Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Houston, TXCrew's failure to follow taxi instructions and to insure that they were on the proper runway prior to initiation of the takeoff roll.NTSB ATL89DKJ02Accident · No injuriesFinal reportAircraft Parts & Dev. A-9B · Athens, ALThe pilot's inadequate preflight preparation/planning to assure sufficient runway length for clearing obstructions.NTSB LAX89LA123Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Watsonville, CAThe pilot's improperly planned approach, and his failure to maintain clearance from the wind sock pole. The proximity of the wind sock (arpt facility) was considered to be a related factor.NTSB MIA89FA100Accident · 2 fatalField investigationFinal reportBeech S35 · Daytona Beach, FLThe pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…NTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.NTSB SEA89LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forrest Grove, ORThe pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.NTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.NTSB LAX89DVA06Accident · Serious injuriesFinal reportGrumman G-164A · Riverdale, CAInadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.NTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.NTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.NTSB FTW89LA054Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Brownsville, TXThe pilot failed to compensate for the existing wind conditions and maintain proper alignment with the runway. The wind conditions and the sunglare are considered to be contributing factors to the accident.NTSB ATL89LA089Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wilmington, OHThe failure of the pilot to adequately compensate for wind conditions, to maintain proper runway alignment, and his delay in aborting the landing. Contributing factors were: variable crosswind conditions and a small tree.NTSB LAX89LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Sacramento, CAThe pilot's selection of the wrong runway for landing and his delay in initiating a go-around after landing long. Contributing factors were: light conditions as dusk and a tailwind.NTSB LAX89LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Green Valley, AZThe student pilot displayed poor judgement in not maintaining proper altitude. A factor contributing to the accident was the pilot's overall lack of experience.NTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.NTSB NYC89LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Hammonton, NJA bird strike shortly after takeoff.NTSB LAX89DVA03Accident · Serious injuriesFinal reportBell 47G-3B2 · Strathmore, CAImproper compensation for wind conditions by the pilot, and his failure to maintain clearance from the service truck. Factors relating to the accident were: the unfavorable (variable) and gusty wind conditions and close proximity of the service vehicle.NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.NTSB LAX89FA092Accident · 2 fatalField investigationFinal reportRobinson R22A · Santa Barbara, CAFailure of the pilot to maintain adequate altitude, proper airspeed for the reduced visibility, and an adequate visual outlook to avoid a collision with power transmission cable. Contributing to the accident was reduced visibility due to fog.NTSB FTW89DRA02Accident · Serious injuriesFinal reportPitts S1A · Santa Fe, TXPilot in command failed to maintain adequate altitude and clearance on final approach.NTSB LAX89LA087Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZImproper in-flight planning/decision by the pilot and his inadequate visual lookout (failure to see-and-avoid the obstruction). Factors related to the accident were: the birds, the pilot's excessive maneuver, and the transmission line.NTSB LAX89DUJ03Accident · 1 fatalFinal reportMurphey Vancraft 532 · Tucson, AZInadequate lookout by the pilot during unwarranted low flight.NTSB ATL89FA071Accident · Serious injuriesField investigationFinal reportCessna 208B · Madison, NCImproper IFR procedure by the pilot and his failure to maintain the minimum descent altitude (mda). Contributing factors were: low ceiling, fog, delayed missed approach by the pilot, and trees.NTSB NYC89LA060Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Speculator, NYInaccurate inflight planning and decisions by the pilot who inadvertently flew his aircraft from VFR into instrument meteorological conditions while making a descent at night.NTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.