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 20020619020209ACessna 180 · Jacksonville, FL(-23) Pilot receiving tail wheel instruction, lost control after landing, ground looped aircraft; damaged rt landing gear, rt wing tip. An FAA inspection of the aircraft found no discrepancies which would have contributed to the accident.Incident 20020619019309IAmtr VP1 · Westhampton Bea, NY(-23) On approach to landing on runway 33 at west hampton/Gabreski airport, the pilot stated that the aircraft became erratic in handling. Pilot lost control and decided to land on the grass shoulder of the runway. On impact, the propeller struck the…Accident 20020619016809ADhav DHC6300 · Ketchikan, AK(-23) N353PM was tied to the dock behind N235SA. Both aircraft were loaded with passengers, preparing for a flightseeing tour. N353PM'S engines were running. The pilot signalled the ground person to disconnect the aux. Power cable. The ground person…Accident 20020619016209AConaer LA4200 · Puyallup, WA(-23) While executing a landing to the north the aircraft touched down then "ballooned to the left." The pilot added power to go-around in an effort to avoid obstructions on the ground. The aircraft failed to clear trees to the northwest of the runway,…Incident 20020619014909IBeech T42A · Greenville, TX(-23) On June 19, 2002, at 1940 central daylight time, a Beechcraft BE55, N37PA, sustained minor damage when it encountered a gear-up landing on rwy 17 at Majors field, Greenville, Texas. The private pilot, sole occupant of the aircraft, was not injured.…Incident 20020619014589IMooney M20R · Fayetteville, TN(-23) Pilot stated that she was participating in the all women air race classic. One of the check in points was Fayetteville, TN. She said that while landing on runway 20 at fym she was distracted by machinery operating near the runway. She then allowed the…Incident 20020619014539IBeech 2000 · Ft Myers, FL(-23) On June 19, 2002, at 1744 hours EDT, a Beech starship 2000, N786BP, registered to 86 bp, inc, experienced the loss of a main landing gear wheel while on a part 91 flight. Visual meteorological conditions prevailed at the time. The aircraft sustained no…Accident 20020619014369APiper PA46310P · Naples, FL(-23) Witnesses stated that there were two popping sounds that came from the aircraft, at about 100 ft to 200 ft AGL, after takeoff. At that point the aircraft started a right turn. The aircraft stalled and spun into the ground in a near vertical attitude.…Accident 20020619014309ACessna 182Q · Leomore, TN(-23) N759TY, CE-182 was en route from hot springs, Arkansas to fayetteville, Tennessee, when the aircraft engine quit due to fuel exhaustion. Pilot made an emergency landing in a field. During the landing the nose landing gear collapsed and the airplane…Accident 20020619013759ACessna 152 · Pittsburgh, PA(-23) On June 19, 2002, about 1635 EDT, a Cessna 152, N95035 was taxiing to parking after the student pilot had finished his second solo flight. As the student pilot approached the parking area, he saw someone walking and went left of the yellow line. The…Accident 20020619013649ACessna 172M · Telluride, CO(.19) On June 19, 2002, at 1030 mountain daylight time, a Cessna 172M, N9089H, piloted by a commercial pilot, was substantially damaged during a hard touch and go landing at the Telluride Regional Airport, Telluride, Colorado. Visual meteorological conditions…Incident 20020619013199IBeech 300BEECH · Prineville, OR(-23) During landing at Prineville Airport (S39) N83RH left the runway to avoid hitting another aircraft on a crossing runway. This incident aircraft was landing on runway 28. After leaving the runway the aircraft props were damaged. FAA inspector john r.…Accident 20020619012759AAmtr Wagabondtvel · Talkeetna, AK(-23) Airman was taxiing on a gravel bar downwind to a parking spot. The aircraft nosed over when a gust of wind struck the aircraft from behind.Accident 20020619012559AAmtr RV6A · El Paso, TX(.19) On June 19, 2002, at 0919 mountain standard time, a quinn, RV-6A, experimental homebuilt, single-engine airplane, N799RQ, impacted the terrain during a forced landing following a loss of engine power near the El Paso International Airport, El Paso,…Accident 20020618021549AAmtr HORIZON1 · Niles, MI(.19) On June 18, 2002, at 2000 eastern standard time, an amateur-built hulle horizon 1, N816DJ, sustained substantial damage during a bounced landing at Jerry Tyler Memorial Airport (3TR), Niles, Michigan. The 14 CFR part 91 personal flight departed 3TR and…Incident 20020618018889IBeech C99 · Billings, MT(-23) On 06/19/2002 @ 1928 ameriflight flt #1689 was on approach to Billings, Montana airport (bil). The crew noted an electrical odor in cockpit. The aircraft landed without incident. Maintenance discovered a burnt circuit breaker to audio panel. Removed &…Accident 20020618016739APiper PA18A · Anchorage, AK(-23) Airman was attempting to land on lake Hood gravel strip. The aircraft bounced twice on landing and went off the left side of the runway.Accident 20020618016139AYaklev YAK52 · Antioch, CA(-23) Witnesses saw the aircraft conducting low level aerobatics when it crashed. The aircraft impacted vertical. (.19) on June 18, 2002, at 1238 pacific daylight time, a yakolev yak 52 airplane, N644LL, was destroyed when it impacted the ground while…Incident 20020618015569ICessna R172E · Colorado Spring, CO(-23) Student pilot performing a soft field landing on runway 17R at cos. Student pilot lost control of aircraft during landing. Aircraft damage prop on dirt shoulder of runway.Incident 20020618015139IPiper PA28151 · Mesa, AZ(-23) On June 18, 2002 at 1145 MST, Piper pa 28-151, N33439 sustained minor damage when the engine compartment caught fire on the ramp during engine hot start. The pilot and passenger were not injured. The fire was extinguished by the maintenance crew.Incident 20020618014689IBeech 58 · Greensboro, NC(-23) On June 18, 2002, at approximately 1430 EDT, a Beech BE-58 registered to bellefonte, inc. a FAR 135 operator, 3704 stonegate dr., durham, NC 27705 made an emergency landing at raleigh-durham airport. Elizabeth coykendall was the pilot in command. The…Incident 20020618014029IMncoup 110SPECIAL · Leesburg, FL(-23) During takeoff roll, aircraft swerved to right. Pilot corrected to left and left gear folded under due to wire bracing. Aircraft exited runway into grass on right side of runway, struck propeller and left wing tip. Damage to lower cowl, prop, left gear,…Incident 20020618013219ICessna 172P · Florala, AL(-23) N89811 owned by pensacola navy flying club. Aircraft was operated by Mr. Donald von der osten. Pilot stated his approach into Florala, AL airport (O4J) was too steep. Aircraft bounced and propeller struck runway. Minor physical damage sustained by…Accident 20020618013019ACessna 441 · Medford, OR(-23) Right main landing gear collapsed on landing. Cockpit indications showed "unsafe" retraction and "safe" gear extension for landing. Forward pivot trunion moved forward because the securing roll pin appeared to have failed. Gear slipped from the trunion…Incident 20020618012459ICessna P210N · Pinedale, WY(-23) This aircraft had just received an annual inspection. During the preflight inspection the pilot failed to notice the gear handle was not in the down position. The pilot turned on the master switch and said the gear indicator light indicated green (gear…Accident 20020617038289APiper PA28* · Huron, OH(-23) Instructor and student, age 65 and 66, were performing takeoffs and landings. Winds were light and weather was VFR. The student, whose medical was denied and was taking instructions pending review, was operating the controls from the left seat. The CFI…Accident 20020617021949ABeech V35A · Leslie, AR(-23) On June 17, 2002, approximately 0908 central daylight time, a Beech 35-V35A, N800MD, impacted the terrain during an emergency landing following a loss of engine power at cruise altitude near Leslie, Arkansas.Incident 20020617020929IDoug DC863F · Detroit, MI(-23) Aircraft 865F was taxiing for take off when the left wing tip struck the tail cone of parked aircraft N344HA. The flight crew of N865F indicated that they did not realize the wing tip was damaged until maintenance notified them, after they returned from…Incident 20020617019459ICessna 172RG · Schenectady, NY(-23) Commercial pilot student was practicing touch and go landings with an instructor when the nose landing gear collapsed during take off sequence. The instructor stated the approach and landing were normal with a safe gear indication. After aircraft came…Incident 20020617019159IBoeing 737301 · Syracuse, NY(-23) On Monday, June 17, 2002, after takeoff from runway 28 at Syracuse Hancock International Airport, the nose gear would not retract on N585US, a Boeing 737-300 operated by usairways. The aircraft returned to the airport and landed without incident. The…Incident 20020617018959IPiper PA28236 · Farmingdale, NY(-23) On June 17, 2002, at approximately 1415L the pilot of N3008K, a PA-28-236, attempted to reposition the aircraft. The pilot lost control of the aircraft as it struck the fuel farm and 2 fuel trucks at atlantic aviation on the "hotel" parking ramp. The…Accident 20020617017679ACessna 177B · Richmond, VA(-23) While performing a night landing in VFR conditions, the pilot landed hard and porpoised several times before coming to a complete stop on the runway. The pilot sustained a compressed spine and was hospitalized for 6 days. The aircraft received…Accident 20020617017229ACessna 182A · Fostercity, MI(-23) Aircraft was doing wildlife survey (wolf tracking). Wreckage indicates high speed controlled flight into trees. Pilot received fatal injuries, unable to locate pilot logbooks, flight times are unknown estimated from aircraft maintenance records and FAA…Incident 20020617016369ICessna 177 · Roanoke, TX(-23) On June 17, 2002, at 14:45, a Cessna 177, N29409, owned and operated by blake w. windham, [privacy data omitted] made a forced hard landing on a training flight. Visual flight rule conditions prevailed and no flight plan was filed. The aircraft…Accident 20020617016019ALear 35A · Oxford, CT(-23) The flight's purpose was to train a new pilot in the Lear 35A for a part 135 air carrier. Upon landing, the pilot deployed thrust-reversers. The company instructor directed that a touch and go be initiated. The thrust-reversers had not fully stowed when…Incident 20020617015579IBeech B36TC · Eagle, CO(-23) Aircraft lost electrical power in the vicinity of Eagle county airport. Pilot decided to land at Eagle county airport with no communication with the tower. Aircraft was landed gear up on runway 25 at Eagle county airport.Accident 20020617015359ACessna 180K · Helena, MT(-23) The pilot stated that on takeoff the aircraft would not accelerate to takeoff speed, so he elected to abort the takeoff. When he applied brakes, the right brake had no effect, causing the aircraft to swerve and continue into a ground loop. The aircraft…Incident 20020617014679ICessna 320 · Anderson, SC(-23) Nose gear would not extend on landing. Pop was heard under floor of cockpit when gear was retracted. Nose gear collapsed on landing. No injury or fire. Minor damage to nose radar dome, nose gear doors both propellers sustained major damage. Inspection…Incident 20020617014019ICessna 210N · Birmingham, AL(-23) Pilot stated that due to additional traffic, air traffic had him keep his speed up and start his descent later than he normally does. Due to this change in his routine he landed with the gear in the retracted position which resulted in minor damage.Incident 20020617013309IPiper PA38112 · Pensacola, FL(-23) On June 17, 2002, student pilot was conducting first solo takeoffs and landings at Pensacola Regional Airport. On the third landing the right landing gear collapsed and the aircraft skidded to the right side of the runway. Initial investigation…Accident 20020617012619ALkheed C130A · Walker, CA(-23) Both wings separated from the fuselage during a firefighting retardant drop.Accident 20020617011549AGrumav G21 · Northway, AK(.19) On June 17, 2002, about 1204 Alaska daylight time, an amphibious Grumman goose G-21 airplane, N21A, sustained substantial damage during landing at the Northway Airport, Northway, Alaska. The airplane was being operated as a visual flight rules (VFR)…Accident 20020616038089ALBL 90ALBL · Mukwonago, WI(-23) On June 16, at approximately 2005 CST a lindstrand model 90A, N40051, executed a high wing landing procedure near Mukwonago, WI. The balloon landed hard and was dragged some distance before the envelope deflated. The commercial pilot remained in the…Accident 20020616037329ACessna 172G · Butler, MO(-23) The flight originated in rapid city, south dakota, and after about 5 hours in the air the pilot decided to refuel at Butler, Missouri. During letdown to the traffic pattern, the engine quit due to fuel starvation. The pilot was unable to restart the…Incident 20020616034409IPiper PA18150 · Menard, TX(-23) On June 16, 2002, at approximately 4 miles north of the Menard, Texas airport and shortly after takeoff the aircraft lost engine power, then the engine quit. The pilot and one passenger made a forced landing in a field. The aircraft struck the ground…Accident 20020616027499ADoug DC982 · Kansas City, MO(-23) On June 17, 2002 at 09:00, Mr. Tim huff chief inspector of vanguard airlines notified this office, that on June 16, 2002 at 20:30 hours after being called out to aircraft N140NJ for a reported APU would not start on landing. Maintenance personnel…Incident 20020616021189IAerosp ATR72202 · Peoria, IL(-23) [privacy data omitted] during cruise flight, approximately 130 miles south west of the destination airport, south bend, IN., the number 1 engine lost oil pressure. The checklist required the engine to be shut down. The crew declared an emergency and…Incident 20020616019679IAmtr CA8 · Orlando, FL(-23) The pilot stated that after a normal landing on clear lake in Orlando FL. The floats were not aligned with the fuselage. As the nose of the aircraft started to tuck, he applied aft controls. The aircraft continued to tuck until it came to rest inverted.…Accident 20020616017729ASchler ASK21 · Woodstock, VA(-23) Pilot stated that he was ridge flying, lost lift, made decision too late to try to find a place to land. While trying to make a turn back to the ridge lift, aircraft stalled, mushed into the treetops. Aircraft then fell through the trees. The aircraft…Accident 20020616017549AAmtr Variviggen · Urbana, IL(.19) On June 16, 2002, at 1030 central daylight time, a rutan vari viggen, N915D, piloted by a commercial pilot was destroyed following impact with terrain on initial climb from runway 27 (4,000 feet by 57 feet, concrete), at the Frasca Field Airport (C16),…