FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 20020902023579ASnias AS350B3 · Eagle Pass, TX(.19) On September 2, 2002, at 1440 central daylight time, a Eurocopter AS350B3 helicopter, N747R, was substantially damaged during a forced landing following a loss of engine RPM control near Eagle Pass, Texas. The helicopter was registered to sage well…Accident 20020902023119ACessna 150F · Deming, NM(.19) On September 2, 2002, at 1031 mountain daylight time, a Cessna 150F single-engine airplane, N8351G, was substantially damaged following a loss of control during takeoff from a private airstrip near Deming, new Mexico. The non-instrument rated private…Accident 20020902022419AScwzer SGS134 · Decatur, TX(-23) On September 2, 2002, at 6:00 p.m. CDT, a Schweizer, model sgs 1-34 glider, N2691H, registered to north Texas soaring of Decatur, Texas, crashed during an approach to Decatur Municipal Airport, on a 14 CFR part 91 pleasure flight. Visual meteorological…Incident 20020901030889IMooney M20R · Liberal, KS(-23) Aircraft departed dear valley, Arizona on 9/1/02 to Liberal, KS. Upon landing at Liberal, the gusty wind died off unexpectedly contributing to a hard landing. The right main landing gear collapsed. After the gear collapsed, the prop struck the runway…Incident 20020901029619IBeech 58TC · Mecosta, MI(-23) BE-58, N66568 was back taxiing for departure on runway 18, CE-172 (N8142X) turned final for 18. BE-58 exited runway to avoid the CE-172 which landed on runway 18. The BE-58 taxied into a shallow ditch and struck a prop, minor damage occurred.Incident 20020901028769IBoeing 767332 · CA(-23) On September 1, 2002, aircraft N178DN a Boeing 767-300, took off on flight 1990/600 heading to atl. During climb after the flaps were moved to the fully up position, the leading edge asymmetry eicas message and warning lights were displayed. The…Accident 20020901028469AAmrgen AA5A · Greenville, TN(-23) On September 1, 2002, about 1650 eastern daylight time, a Gulfstream American AA-5A, N9807U, registered to and operated by a private individual, as a title 14 CFR part 91 personal flight, crashed shortly after takeoff at Greenville, TN. Visual…Incident 20020901027049IBoeing 747 · Los Angeles, CA(-23) After departure from auckland new zealand the right inboard fore flap attach point p/n 65B39025-29 failed. The broken (half round) attach piece was recovered from the canoe by maintenance personnel. Subsequent vibration and flutter caused the flap to…Accident 20020901026559ACessna 152 · Orlando, FL(-23) The student pilot stated that on final for runway 9 the aircraft landed on both main landing gear. On roll out the aircraft turned to the left on to the grass. The nose wheel hit an embankment then flipped over causing substantial damage.Accident 20020901026509AAmtr CHALLENGER2 · Plymouth, FL(-23) The pilot stated that his final approach to runway 33 was low. The pilot applied power and the aircraft rolled to the right then nosed downward and struck the trees causing the aircraft to impact with the ground. The aircraft had substantial damage.Accident 20020901026459ACessna T337D · Fort Pierce, FL(-23) Aircraft crashed into drainage canal three quarters of mile short of Fort Pierce airport runway 9. The pilot stated that the front engine shut down and he tried to restart the engine while do that the rear engine quit. The aircraft crashed and stopped…Accident 20020901025989APiper PA18 · AK(-23) The pilot was landing at a remote off airport site with his Piper PA-18. In his attempt to make the landing, he turned final approach and realized his approach was too high and too close, but continued anyway. This contributed to his excess airspeed…Accident 20020901025869ACessna 185F · Portalsworth, AK(-23) On 9/01/2002 about 0900 adt, a float-equipped Cessna 185 airplane, N185CF, sustained damage during a collision with terrain, about 14 miles southeast of port alsworth, Alaska. The airplane was being operated as a visual flight rules (VFR) local area…Accident 20020901024299ABbavia 7ECA · Stow, MA(-23) After landing on runway 30 at minuteman Stow airport, aircraft veered off the runway and collided with a parked automobile located on an aircraft tie-down spot. Both vehicles sustained substantial damage and are considered destroyed.Incident 20020901024049IWSK KOLIBER160A · Conchas Dam, NM(-23) Mr. Hughes was operating an airplane at extremely low altitudes along a highway. A motorcyclist travelling in the opposite direction saw the airplane and began to slow, in an effort to take evasive actions. A second motorcyclist struck the first from…Accident 20020901023979AAmrgen AA5B · Zephyrhills, FL(.19) On September 1, 2002, at 0635 eastern daylight time, an unregistered Grumman American AA5B, N81189, operated by a private pilot collided with trees and a family home while on approach to Zephyrhills Municipal Airport, Florida. The personal flight…Incident 20020901022869ICessna TU206G · Salt Lake City, UT(-23) On 9/1/02 aircraft N6207Z enroute from slc to rno the pilot reported he experienced a partial loss of power and made a precautionary landing 7 miles west of slc and the aircraft became stuck in the mud. Follow up with the pilot william blake milford he…Incident 20020831031279IBbavia 7AC · Topeka, KS(-23) On August 31, 2002, at approximately 1:45 pm local CDT, while acting as PIC of N85181, a BL-7-AC Aeronca champ, Mr. Mark rohrbaugh lost control of the aircraft during a landing operation and deviated from the runway surface. Neither the PIC nor the…Incident 20020831029839IBeech B60 · Ludington, MI(-23) During the landing a deer ran onto the runway and was struck by the aircraft. The aircraft received minor damage to the left main landing gear door and landing light.Incident 20020831029459IMooney M20E · Mineral Point, WI(-23) On August 31, 2002 at 1235 CDT, at Mineral Point, WI, a Mooney M20E, N1982Y, operated by private pilot, william l. baker, landed gear up on runway 29. The aircraft skidded on its belly, damaging the belly and propeller. The aircraft damage was minor and…Accident 20020831028909APiper PA28140 · Price, TX(-23) On August 31, 2002 @ 1600 CDT, a Piper PA-28-140, N3961K, during a flight from canton, Texas to the gregg county airport in longview, Texas, experienced power loss which forced the pilot to land in a field near Price, Texas. The forced landing caused…Incident 20020831027109IBeech F33A · Houston, TX(-23) Pilot stated to ATC that the throttle stuck open on final approach. Aircraft had hard landing breaking the nose wheel from the nose strut. All three propeller blades contacted the runway. Light damage to the belly of the aircraft when the nose wheel…Incident 20020831025729IPiper PA12 · Harlingen, TX(-23) The pilot encountered wind gust on landing rollout causing aircraft to swerve off of runway 17L and strike a taxiway identifier light. Design of the aircraft (conventional landing gear) contributed to the incident.Incident 20020831025659IPiper PA24250 · Collinsville, OK(-23) The pilot, Mr. James c. brown, stated that he departed river side airport in the am of August 31, 2002. He arrived at airman acres in Collinsville, OK a short time later. Around 11:30 the pilot stated that he departed airman acres, did a touch and go at…Accident 20020831025069ACessna 172N · Lakeside, CA(.19) On August 31, 2002, about 1020 pacific daylight time, a Cessna 172, N739ZV, made an off-airport landing in Lakeside, California, following a loss of engine power. Plus one flying club was operating the rental airplane as an instructional flight under…Incident 20020831025009ICessna 172F · Winnemucca, NV(-23) The pilot stated that there was a windshear upon landing and caused the aircraft to swerve off the runway. There was minor damage to the propeller.Accident 20020831024659ACessna 182Q · New Roads, LA(-23) Aircraft stalled on final approach, struck the ground approximately 48 feet short of the runway, bounced back into the air and hit again approximately 45 feet onto the runway, finally coming to a stop approximately 1,000 feet down the runway.Accident 20020831024519AUnivar 415C · Fresno, CA(-23) On 08-31-02 at approximately 1020 hours PDT, Mr. Richard earl bain, a private pilot, was acting as pilot in command of aircraft N87204, an Ercoupe 415-C, with one passenger on board, Mr. Floyd glenn stewart, a student pilot and the owner of the…Accident 20020831023419ACessna 185E · AK(-23) On 8/31/02 at approximately 1900HRS private pilot david stott lost control of N7SR a Cessna 185 aircraft when the right main gear struck a berm while landing on a gravel bar on the stoney river approximately 60 miles northeast of sparrevhon, AK. After…Accident 20020831023399ACessna 172 · West Yellowston, MT(-23) Pilot states he was landing in gusty winds got hit by a cross wind and when he went to correct using brakes the left brake failed.Accident 20020831023269AAmtr BD5 · Corvallis, OR(-23) Pilot lost power in traffic pattern, could not make runway, unable to arrest descent rate, made hard landing with wings level, struck in open plowed field. Engine still running and prop turning after impact. FAA portland inspector wilmeth witnesses from…Accident 20020831023249ALear 25C · Lexington, KY(-23) On August 30, 2002, at approximately 1307 EDT, a Lear 25C was destroyed after landing on runway 4 at the Lexington bluegrass airport, Lexington, KY. The aircraft was being operated as a "lifeguard" operation under 14 CFR 135 on an IFR flight plan. The…Accident 20020831023049AAmtr BREEZYRLU1 · Lasvegas, NV(-23) At approximately 9:00 am on August 31, 2002, private pilot henry stephen nelson flew N3184 over sandstone quarry parking lot in red rock canyon national recreation area at low altitude. He continued up a wash (westerly direction) for about…Accident 20020831023019ASkrsky S76A · Miami, FL(-23) The pilot initiated a normal take-off from the Miami children's Hospital level helipad. The pilot elected to take off east between a building and a multi-deck-parking garage and over an awning covered crosswalk and a street. As the helicopter passed…Incident 20020831022759IPiper PA28R201 · Cortez, CO(-23) The pilot reported by phone and by his written statement on 9/3/02 the fact relating to the incident. He entered a left downwind approach to runway 21 at Cortez, CO. At about the midfield point he reached up and put the gear extension lever in the down…Incident 20020831022689IAmtr F8LFALCO · Coeur D Alene, ID(-23) On Saturday August 21, 2002 at approximately 1010 am local time, N141CJ an F8L falco piloted by Mr. John h. harns, the aircraft owner, landed at the Coeur d'Alene, ID airport (coe) with all three landing gear collapsing during the roll out. The pilot…Incident 20020830037169ICessna 310D · San Antonio, TX(-23) Aircraft N6866T landed on runway 12L and ran off the end of the runway.Incident 20020830037149IWaco UPF7 · Montgomery, NY(-23) NC29925 landed runway 3 mgj, while applying brakes, brake lock-up aircraft flipped forward, damaging the aircraft's propeller, engine cowl and top of rudder.Incident 20020830036999IBeech B200 · Rochester, NY(-23) On Friday, August 30, 2002, during cruise at 26,000', the unsafe gear light came on in aircraft N610TA, a Beech B-200 operated by us airports. The pilot cycled the gear and the light came on again. The crew returned the aircraft to the Rochester…Incident 20020830030809IPiper PA28RT201 · Tucson, AZ(-23) On approach to tus gear was placed down and the right gear indicated unsafe. The gear was cycled and still indicated unsafe a fly by was accomplished and the tower indicated the gear was down. The gear was placed in emergency down with no change the…Accident 20020830027579ACessna 195 · Shenandoah, IA(-23) Pilot lost control on landing. The aircraft bounced and flipped over on it's back. Substantial damage occurred to the aircraft.Accident 20020830026449ACessna 210L · Georgetown, SC(-23) On August 30, 2002, at approximately 0915 hours local, N32W, a Cessna 210L aircraft, experienced a loss of electrical power approximately 20 miles south of the Georgetown airport (gge), SC. The pilot attempted to lower the landing gear electrically, but…Incident 20020830026299IBeech A36 · Fairhope, AL(-23) After installing a new engine fuel system, a test flight was performed on the aircraft. Upon landing the nose wheel collapsed. After the aircraft slid off the right side of the runway, the right main gear also collapsed. The pilot stated that neither he…Incident 20020830025639IBeech B24R · Dauphin Island, AK(-23) Pilot landed in gusty winds and became airborne again after touchdown. He stated he lowered the nose and caused damage to nose wheel and prop.Incident 20020830025619IPiper PA28181 · Fairhope, AL(-23) After completing a cross country flight the pilot landed and ran off the right side of the runway due to a crosswind and his inattention. He struck a runway light and the aircraft sustained minor damage to the wheel pants.Incident 20020830025439ICessna 172P · Colorado Spring, CO(-23) The aircraft struck an antelope on the runway during the takeoff roll in the dark. Damage was limited to the nose wheel and left main landing gear strut.Incident 20020830025399IHelio H295 · AK(-23) [privacy data omitted] on August 30, 2002 at about 1800 local time, a Helio-courrier aircraft, N6465V, was landing at an off airport strip when the right main landing gear collapsed. The gear leg had broke just below the support strut from fatigue.Accident 20020830025389ABell 206L3 · Canoncity, CO(-23) The pilot was returning to the helipad from the royal gorge when he struck a wire on a electrical power line while maneuvering during low level flight in a remote area, (blm land). The wire strike damaged the helicopter's rotor systems pitch change…Accident 20020830024009AAmtr Experimental · Panacea, FL(.19) On August 30, 2002, at 1500 eastern daylight time, a john barker Experimental airplane, N9097F, registered to and operated by the pilot, nosed over inverted during landing at the Wakulla county airstrip in Panacea, Florida. The personal flight was…Incident 20020830023149IPiper PA18150 · Ocean City, MD(-23) Aircraft pulling banner lost power and had to land in the Ocean. Pilot was not harmed. Aircraft received minor damage from impact with the water. Aircraft was damaged by fire department while removing it from the water. After investigating the incident,…