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 20020730021449AWhite D25NEWSTD · Oshkosh, WI(.19) On July 30, 2002, at 1037 central daylight time, a White new standard D-25, N176H, was substantially damaged during a forced landing, after a reported partial loss of engine power, near the Wittman Regional Airport (osh), Oshkosh, Wisconsin. Visual…Accident 20020730021349AAerosp SA315B · Estespark, CO(-23) Fatal helicopter accident involving N3978Y, an aerospatiale SA315B lama, at the big elk incident, within arapahoe-roosevelt national forest on July 30, 2002. Aircraft was engaged in dropping water on hot spots when the pilot radioed "helicopter going…Accident 20020730018819AReims F172N · Nykoebingmors, DA(.19) On July 30, 2002, about 1600 UTC, a Cessna F172N, registration oy-bne, registered to and operated by benair a/s, collided with trees during a go-around from landing at the morsoe airfield airport, nykoebing mors, denmark. Visual meteorological…Accident 20020730018689ACessna 210L · Cascade, ID(-23) On short final with everything normal, the aircraft suddenly settled. Pilot added full power but could not arrest the descent. Aircraft landed short of the runway in a marshy area. All three landing gear were torn off the aircraft but it stayed upright.Accident 20020730017599AN9639G · Nickerson, KS(.19) On July 30, 2002, at 2050 central daylight time, a Cessna A188B, N9639G, operated by rice county aerial sprayers, inc. was substantially damaged during a forced landing following a total loss of engine power while spraying an agricultural field. Visual…Accident 20020730017239ARobsin R22BETA · Madera, CA(-23) On 07-30-02 at approximately 0915 hours PDT, Mr. Andreas gschwari, a commercial-flight instructor pilot, was acting as pilot in command at the controls of a Robinson R-22 helicopter, giving flight instructor instruction to Mr. John sturdevant, a…Accident 20020730017119APiper PA31350 · Fairbanks, AK(.19) On July 30, 2002, about 1340 Alaska daylight time, a Cessna 172 airplane, N739PB, sustained substantial damage during an on-ground collision with a Piper PA-31 airplane, N3527U, at the Fairbanks International Airport, Fairbanks, Alaska. The two…Accident 20020730016479ACessna 172N · Fairbanks, AK(-23) On July 30, 2002, about 1340 Alaska daylight time, a Cessna 172 airpolane, N739PB, sustained substantial damage during an on-ground collision with a Piper PA-31 airplane, N3527U. The two airplanes collided as the Cessna 172 was taxiing for takeoff, and…Accident 20020729037789ARobsin R22BETA · Madison Heights, VA(-23) The pilot landed on his personal helipad, which had an incline on its end, sloping from the pad's flat surface to ground level. The helicopter tipped rearward as it set down with the rear section of the skid over the inclined end of the pad. The pilot…Incident 20020729037079IDhav DHC8102 · Syracuse, NY(-23) On 7/29/02, N826EX, DHC-8-102, the crew manually extended the landing gear inbound to Syracuse Hancock International Airport, Syracuse, NY. The ARFF responded and the aircraft taxied to the ramp without incident. The crew reported #2 hydraulic isolation…Accident 20020729024439ACessna 182Q · Mc Allen, TX(-23) On 7/29/02, Cessna 182 with PIC robert hardy ran out of fuel on approach to Mc Allen, TX airport. The aircraft struck a berm which flipped the aircraft onto its back. The aircraft was destroyed. The pilot was the sole occupant, he only sustained minor…Accident 20020729021369AScwzer G164A · Portallen, LA(-23) While making aerial application the pilot pulled out of turn to align with field. Just after the turn the pilot noticed that his airspeed was too slow. The aircraft snapped to the left, rolled once and hit the ground at about a 45 degree angle.Accident 20020729018709ACessna R182 · Puyallup, WA(-23) On July 29, 2002 at approx 1630 hrs PDT marshall l. collins a CFI and michael a. welch a student with a private pilot certificate departed Thun field (1S0) Puyallup Washington on a local flight for the purpose of flight instruction in a Cessna R182,…Accident 20020729018489ACessna T188C · Choteau, MT(-23) Pilot stated engine failed on base leg to landing.Accident 20020729017619APiper PA30 · Abilene, KS(.19) On July 29, 2002, at 1415 central daylight time, a Piper PA-30, N90TC, was substantially damaged when it collided with trees and wires shortly after takeoff from runway 35 (4,100 feet by 75 feet, dry asphalt) at the Abilene Municipal Airport, Abilene,…Accident 20020728038189APiper PA28235 · Kelleys Island, OH(-23) On June 29, 2002 at approximately 19:30 hours local. A Piper (N15442) model PA-28-235 piloted by a Mr. Paul d. hiller was attempting to land at Kelleys Island airport (89D) runway 9. Upon attempted landing he encountered a severe downdraft, causing the…Accident 20020728037849APerth Birdck · Staunton-Waynes, VA(-23) At 1910 local, July 28, 2002, at Shenandoah Valley Regional Airport, a bird ck (antique biplane) NC99754, struck two aircraft which were both tied down on the parking ramp while attempting to return for a landing after suffering an engine power loss.…Incident 20020728037179IStolam RC3 · La Belle, FL(-23) Pilot in command stated it was normal approach and landing with gear indicating down and locked. Upon touchdown main gear collapsed settling on keel. Investigation revealed the "h" fitting on the landing gear retract linkage failed allowing the gear to…Incident 20020728037129ICessna 172C · Portmouth, VA(-23) At about 1500 local time the pilot was taxiing to runway 28 when he realized that he did not program the GPS correctly. He continued to the end of the taxiway out of the way of traffic. After reprogramming the GPS, he turned the aircraft around for…Accident 20020728032219ABoeing E75 · Leesburg, FL(-23) Pilot's statement: re: N1242V, 1941 stearman, on 7/28/02 @ approx 1PM, departing a private grass strip sw of lee: on take-off at approximately 100 feet AGL, the engine coughed, sputtered and started to quit. We had taken off into the wind, on a basic…Accident 20020728027029APiper PA18A · Portalsworth, AK(-23) Pilot landed on a ridge top and on landing roll wind picked up tail of the aircraft causing the aircraft to nose over causing substantial damage to the aircraft.Incident 20020728022309ICessna 172S · Page, AZ(-23) Pilot reported taking off on runway 33. Wind was 260/290 at 12 KTS. Ground roll reported normal with continued input of left aileron and rudder to maintain directional control. The aircraft then started to drift to the right side of the runway and…Incident 20020728022139IAmtr Glasairiirg · Midland, TX(-23) On July 28, 2002, at approximately 13:00 CDT, local time, the pilot of a glassair aircraft, N129DS, made a hard landing at sky west inc. airport (7T7), located 8 miles southeast of Midland, Texas. During the subsequent hard landing, the attachment four…Accident 20020728021419ACessna R172K · Flushing, MI(.19) On July 28, 2002, at 0840 eastern daylight time, a Cessna R172K, N1086V, piloted by a private pilot, sustained substantial damage when it impacted a curb after an aborted takeoff following a reported loss of engine power during takeoff from runway 36…Incident 20020728020619ICessna 177RG · Dayton, OH(-23) Aircraft departed fld en route to I73 Moraine air park Ohio. One hour into the flight the pilot heard a loud pop and saw the main landing gear was no longer in the up position. An attempt was made to lower the gear both in normal and emergency without…Incident 20020728019569IMooney M20J · Goldsboro, NC(-23) According to his statement, the pilot (patrick dale) lowered landing gear lever at 130 knots after turning downwind for runway 23. While on final approach and before crossing runway threshold Mr. Dale completed a visual sweep of instruments and…Incident 20020728019439ICessna 172N · Driggs, ID(-23) The student pilot, with approx. 24 hrs, landed at U59 (Driggs, ID), during the landing he exited runway 21 into an irrigation ditch. The pilot flared high, the aircraft crabbed to the right, upon touchdown, the pilot added left rudder to line up the…Incident 20020728019389IAmtr RANSS7 · Pocatello, ID(-23) Upon landing on runway 21 at pih, the wind was 270/08 @ 1756Z, the pilot stated he floated and added power and landed. When the right wheel contacted the runway the landing gear failed. The aircraft dug in and and the pilot added opposite brake and…Incident 20020728019099IGlaser DG500MB · Richland, WA(-23) This aircraft is a motorized glider. The engine assembly is raised and lowered by a motorized linear. The jackscrew of the actuator failed and allowed the engine assembly and propeller to make an abrupt and uncommanded retraction while the aircraft was…Incident 20020728017309ITcraft F19 · Palmer, AK(-23) Upon landing to an unimproved runway, pilot touched down extremely firm and began to bounce. After numerous bounces left landing gear folded back and allowed prop to strike the ground. Aircraft came to rest with only minor damage and no injuries. A/c…Accident 20020728017159AAmtr Rotorhorse · Capecoral, FL(.19) On July 28, 2002, at 1102 eastern daylight time, an aurandt rotor horse unregistered experimental gyrocopter, owned and operated by an individual, collided with the ground following a loss of engine power in cape coral, Florida. The personal flight was…Incident 20020727027269IAmtr Glassgoose · Kismet, KS(-23) On 07/27/02 an experimental amateur built (glass goose) operated by barry lee cohen (certificate no. 526649063) made an uneventful emergency landing, on a rural road approximately one hour after departing the salina municipal airport, (salina, KS). The…Accident 20020727019519ABrwstr FLEET7DELUXE · Canyon, TX(-23) On July 27, 2002, at approximately 10:49 CDT, local time, the pilot of a fleet model A-7 biplane aircraft, N790V, experienced engine failure. According to the pilot in command, while in flight the aircraft experienced an inadvertent loss of power. The…Accident 20020727018649ACessna T210F · Willits, CA(-23) The pilot landed N6776R long (touch down on the last third) on runway 34 at Willits, CA (O28) and slid off the end of the runway. The aircraft slid over a 15 foot embankment and landed upside down causing substantial damage to the aircraft.Accident 20020727018519ACessna 177B · Dubois, WY(-23) While enroute on a VFR flight plan, aircraft crashed on the side of a mountain, 100 ft. from the top. The accident was performance related. Item 31. Some pilot information is missing.Accident 20020727017299ACessna TR182 · Copemish, MI(-23) Enroute from ludington to traverse city the smell of smoke became evident to the occupants. The pilot began descent for an emergency landing. During the descent the smoke and now fire intensified, requiring the pilot to open the window and put his head…Accident 20020727016899AAirtrc AT502 · Sanmanuel, AZ(.19) On July 27, 2002, about 1130 mountain standard time, an air tractor AT-502, N293JK, collided with mountainous terrain approximately 13 miles southwest of san manuel, Arizona, while maneuvering in a box canyon. The airplane, operated by devil dusters,…Accident 20020727016789ARaven S77A · Fairburn, SD(-23) July 27, 2002, pilot scott nash notified the rap FSDO of an aircraft accident that occurred at 6:45 am at Custer State park. The aircraft reported was an Aerostar S77A balloon with eight passengers. The aircraft made a hard landing and two passengers…Accident 20020727016779ARobsin R22BETA · Prescott, AZ(-23) Aircraft was on a training flight, when the instructor was demonstrating an auto-rotation for the student. During the procedure, the aircraft entered a dust-devil inadvertently which caused the aircraft to settle at a rate that could not be arrested…Accident 20020726035619AAirtrc AT301 · Malta, IS(-23) After agricultural operation was completed engine quit and aircraft landed in a cornfield.Accident 20020726030569ABoeing 727232 · Tallahassee, FL(-23) While on visual approach to runway 9, the aircraft struck some trees and crashed approximately 1/2 mile from the approach end of runway 9.Incident 20020726027329ICessna 180K · St Louis, MO(-23) PIC howard clark reported that he lost control on landing in crosswind conditions. He indicated that he had a normal touchdown in the wheel landing configuration when the aircraft began to weathervane to the right on rollout. He said that when he…Incident 20020726027209IBeech P35 · Clarinda, IA(-23) Flight of four aircraft were on a VFR cross country flight to dodge city, KS (ddc) from the Wisconsin dells (dll) with a planned stop in Clarinda, IA (icl). The pilot in command of the number four aircraft was identified as Mr. Hugh robben. He reported…Incident 20020726027129IBoeing 737230 · Kansas City, MO(-23) On July 26, 2002, vanguard airlines, flt. 842 reported to ATC of a foul smell in the cabin due to a birdstrike and declared an emergency. The a/c landed without incident. Maintenance concluded that a bird struck the radome with feathers being ingested…Incident 20020726023859IBeech E18S · Houston, TX(-23) Aircraft departed sugarland municipal airport (sgr) and conducted aerial application operations. Upon return to sugarland the pilot placed the gear selector in the down position but did not get a down indication. The pilot got confirmation that the gear…Incident 20020726022509IPiper PA34220T · Russville, AR(-23) On July 26, 2002, at 0945 central time, a Piper PA-34-220T, N170HS, registered to direct air LLC, touched down on rwy 7 at russellville municipal, russellville, Arkansas. Aircraft landed with gear up, according to the pilot in command there was no gear…Accident 20020726021859APiper PA24250 · Falcon, CO(-23) On July 26, 2002, approximately 1600 hours, PA24-250 N6887P was substantially damaged during a forced landing due to fuel depletion. The aircraft landed on a road approximately 8 miles NE of meadowlake airport (00V). Teh flight originated from sioux…Incident 20020726021729IPiper PA24180 · Muskogee, OK(-23) Pilot stated landing gear failed after landing. Written statements from the pilot and passenger, Mr. Barry cantrell support the incident as stated.Accident 20020726021259ACessna 172S · Georgetown, CO(-23) Aircraft departed bjc and proceeded west on interstate 70 toward gjt. It appears the aircraft was a couple of hundred feet off highway and saw the eisenhower tunnel. The aircraft turned to avoid the hill and hit a smaller hill taking the nose wheel out.…Incident 20020726020939IPiper PA31325 · Fort Collins, CO(-23) Pilot stated that he may have inadvertently hit the gear lever with his knee. Gear handle was in the up & locked position.