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 20020413007459ACessna 172R · Mc Kinney, TX(-23) On April 13, 2002, at 0900 central daylight time, a Cessna 172R, N58AF, sustained substantial damage when it encountered a ditch following loss of control during the landing roll on rwy 17 at the mckinney municipal airport, mckinney, Texas. The student…Incident 20020413007389IPiper PA28140 · Honolulu, HI(-23) On 04/13/02 during a training flight that was conducted under part 141. While on final approach everything appeared to be normal, but upon touchdown the flight instructor and student heard a sound like a blown tire. Flight instructor immediately took…Incident 20020413005939IRaven RX7 · Albuquerque, NM(-23) On April 13, 2002, at 0826 MDT, an Aerostar RX-7 balloon, N91021, registered to blair kaufman, hit a powerline with the bottom third of the basket after aborting a landing due to increasing ground winds in Albuquerque, new Mexico, while on a pleasure…Incident 20020413005789ICessna 172A · Cedar City, UT(-23) A/c taxied off end of runway at cdc.Incident 20020413005739IMooney M20E · Miami, FL(-23) Pilot statement: Mr. Spear stated the approach to the runway was normal. The landing gear handle was in the down position and had a green light but may not have been in the detent position. On touchdown between 70 and 80 knots the aircraft began to slow…Accident 20020412013509ACessna 172F · Smithfield, NC(.19) On April 12, 2002, at 2340 eastern daylight time, a Cessna 172, N8458U, registered to air taxi inc., and operated by the pilot, collided with tree and power lines while maneuvering for an emergency landing near Smithfield, north carolina. The personal…Incident 20020412008489IMooney M20F · Council Bluffs, IA(-23) Upon entering the landing pattern, the aircraft had an unsafe gear indication. Numerous attempts were made to cycle the landing gear using the gear switch and the emergency gear extension handle. All attempts resulted with an unsafe indication. A…Accident 20020412007079ACessna 172R · Longview, TX(-23) On April 12, 2002, at 1600 central daylight time, a Cessna 172R, N61LU, was substantially damaged when it collided with a bird while on a VFR approach at Gregg County Airport, Longview, TX. The private pilot, sole occupant of the airplane, was not…Accident 20020412007029APiper PA34200T · Oxford, CT(.19) On April 12, 2002, at 2135 eastern daylight time, a Piper PA-34-200T, N82284, was destroyed after impacting trees then terrain while executing the ils/dme rwy 36 approach into waterbury-Oxford airport (oxc), Oxford, Connecticut. There was a post-impact…Incident 20020412006359IAmtr Kitfox · Mountainhome, ID(-23) Aircraft found in a meadow near rye grass creek area northeast of mountain home Idaho by motorcyclist on Thursday am 04-11-02. Person that found aircraft reported the incident to the regional operations center (roc) seattle. When interviewed he stated…Accident 20020412005619APiper PA28181(-23) Pilot departed N89 and continued visual flight into IMC. The aircraft flew easterly toward the mohonk preserve, in the area of "under cliff-over cliff", where it crashed into trees and terrain resulting in destruction of the aircraft along with fatal…Incident 20020411018019IAmrgen AA5B · Marietta, PA(-23) Pilot lost control of aircraft on landing runway 9 shearing the nosewheel off causing propeller to strike the ground. Aircraft came to rest to the right of the runway in the grass. There were no injuries or fire related to this incident. This incident…Incident 20020411017909IWSK PZLM18B · Hazleton, PA(-23) Pilot approached ridge line to make a water drop. He proceeded down the ridge when the wind shifted and a cloud of smoke billowed up and obscured his view. On his drop he hit a large branch obscured in smoke. He proceeded down the ridge line and started…Accident 20020411017189ABeech G35 · Willows, CA(-23) The pilot and one passenger were fatally injured when the aircraft broke up in flight 4 miles west of Willows CA. The flight originated from red bluff area at approximately 0930 local time. The flight was conducted under CFR part 91, in VFR weather…Accident 20020411017149ACessna TR182 · Cypress, TX(.19) On April 11, 2002, at 1818 central daylight time, a Cessna TR182 airplane, N9321R, was substantially damaged during a forced landing following a loss of engine power near Cypress, Texas. The airplane was registered to red bird flyers inc., of…Accident 20020411014199APiper J5A80 · Pahokee, FL(-23) During climbout, pilot lost power and landed hard in a sugar cane field. Post impact fire destroyed aircraft.Incident 20020411012349IPiper PA32300 · Fort Worth, TX(-23) On April 11, 2002 at 1215 pm CDT, a Piper cherokee PA-32-300 aircraft, N33354, owned by SIX4ASIX inc. 3511 silverside rd. ste 105 wilmington, de 19810, and operated by peter brown, collided with a parked automobile while taxiing to the hangar after…Accident 20020411012199ASnias AS350B2 · AK(-23) After about 1 hour a flight time on the day in question, the pilot was picking up a load of skiers and on climb out a warning horn activated and the flight controls became stiff. The pilot reached up and depressed the push button on the console to…Accident 20020411010419AAmtr Steenskybolt · Coeur D Alene, ID(-23) Pilot was unable to maintain control of the aircraft upon landing, aircraft then ground looped on the runway in coe.Incident 20020411008429IBeech 1900D · Pittsburgh, PA(-23) On April 11, 2002, at 11:00 local time, aircraft N244YV on approach to pit lowered the landing gear, and the nose down and lock indicator didn't illuminate. The crew performed a missed approach, and then noticed the gear indicator was on. The crew…Accident 20020411007419ABell 206B · Dallas, TX(-23) On April 11, 2002, at approximately 0800 hrs. Mr. David myer was operating Bell 206B helicopter N513FD on a traffic watch flight with three additional passengers on board the aircraft. When they were in the vicinity of midway road and bobbitt drive…Accident 20020411007159AN908BT · Newsmithville, PA(.19) On April 11, 2002, at 1500 eastern daylight time, a wsk pzl PW-5 glider, N908BT, was substantially damaged during a forced landing near new smithville, Pennsylvania. The certificated private pilot was not injured. Visual meteorological conditions…Incident 20020411006529ICessna 182E · Mt Vernon, IL(-23)[privacy data omitted]- during landing rollout on rwy 23 at mt. Vernon airport, the left wing became airborne causing the aircraft propeller to strike the runway. The airman stated there were gusty crosswinds occurring during the landing. This incident…Incident 20020411006399IBeech E35 · Casa Grande, AZ(-23) Mr. Ronald starling was receiving a flight review from Mr. Everett quamme when they landed gear up. Mr. Starling was not current to act as pilot-in-command.Incident 20020411005709IDiamon DA20A1 · Fremont, CA(-23) Pilot gagot-rivera executed forced un-powered landing due to fuel exhaustion. No injuries to persons or damage to aircraft or property resulted. Flight training was being conducted over the region of the alameda creek trails regional park in Fremont,…Accident 20020411005559AHughes 369D(-23)N8353F, a HU-369-D helicopter received substantial damage when a weight from an animal net hit a main rotor blade. This net was shot from the helicopter utilizing a 308 calabar cartridge to capture elk on the hanford reservation. The estimated…Incident 20020410019529IDeland, FL(-23) On 04/10/2002, I was called to participate in the equipment investigation of a fatal parachute accident. With the help of Mr. T.k. donle, program director for relative workshops, manufacture of the vector I parachute, which was the equipment involved in…Incident 20020410019409IBeech 77 · Palm Springs, CA(-23) During climb out from thermal CA, pilot of N6698Y noticed the oil temperature had climbed into red zone on the oil temp gage. He landed at Palm Springs airport uneventfully. Contacted mechanics who could not duplicate problem. Owner advised him to fly…Accident 20020410013519AAmtr Skyranger · Gila Bend, AZ(-23) Just after takeoff the aircraft engine quit and the aircraft collided with the terrain 200-300 yards from the end of the runway.Incident 20020410012029IBeech D45 · Minooka, IL(-23) During cruise flight, engine experienced a catastrophic failure. Pilot executed an emergency landing in a farm field, no damage to aircraft, no injuries.Accident 20020410010809ACessna 172N · Appleton, WI(-23) On the morning of April 10, 2002 at approximately 4:25 am, at outigamie airport, Appleton WI. A Cessna C-172 N733PX flown by timothy leikip veered left of runway during departure. An investigation was conducted. The investigation revealed that Mr.…Incident 20020410010789IAmtr JETFOX97 · Lakeland, FL(-23) During the landing on the ultralight grass runway at the sun n'fun airshow, the nose gear broke off and the aircraft flipped over on its back. Damage was limited to the nose gear, the fiberglass nose of the aircraft, the propeller, and the rudder. On…Incident 20020410010779IAmtr Mustangthund · Lakeland, FL(-23) While setting up for a pass at the Lakeland airport, during the sun n fun manufacturers showcase, the canopy departed the aircraft. The aircraft was at 500 feet AGL with a speed of approx. 250 KTS. A normal landing was completed after the canopy failed.…Incident 20020410009959IBoeing 767323 · Los Angeles, CA(-23) At approximately 0820, on 04/10/02, American airlines B-767, N39365, which was parked overnight north of the aala maintenance hangar, began to roll forward, broke thru the security fence, and came to rest on world way west road. The #1 engine nose cowl…Accident 20020410009719ABeech E18S · Juneau, AK(-23) N686Q departed Juneau on runway 08, with a load of approximately 77 bundles of wooden roofing shakes, at an average weight of 56 pounds per bundle, bound for taku glacier lodge. This was the aircrafts second trip of the day in which, on the first trip,…Incident 20020410008879IPiper PA24 · Plant City, FL(-23) Pilot attempted to taxi a PA-24-24, N6580P, at night time while his left landing light was inoperative. The aircraft impacted another aircraft, CE-170, N3503D in the right side of the engine area with his spinner/propeller.Incident 20020410008399IZinair CH2000 · Corona, CA(-23) Student pilot landed normally and then lost control of aircraft resulting in skid which led to the aircraft running off the runway into the grass. This resulted in the nose gear collapsing, strut cracking and breaking and the propeller being damaged…Incident 20020410008389ICessna T337G · Stockton, CA(-23) Pilot/owner departed O20 and upon activating landing gear actuator noticed indicator light was not on. Placing the switch to the extend position, the pilot noticed no green light and visual check revealed the left main landing gear was not in sight.…Accident 20020410007669ACessna 172P · Council Bluffs, IA(-23) Student pilot was conducting a solo flight in the traffic pattern. The student stated he was on short final, full flaps at approximately 60 to 65 KIAS. Investigation indicates the pilot allowed the airspeed to dissipate to the point at which the…Incident 20020410007209IBeech 58 · Knoxville, TN(-23) April 10, 2002, mcghee Tyson airport, Knoxville, TN. At 1805 hours. During landing on runway 5R a BE-58 aircraft N6BW, s/n TH-292, struck the runway with left and right props. Prop tips curled on all prop blades. Engines continued to operate. No other…Accident 20020410007179AReport(.19) On April 10, 2002, about 0800 mountain standard time, an unregistered, experimental homebuilt cox sabre skyranger, collided with the ground during a forced landing at gila bend, Arizona. The airplane was operated by the owner/pilot under 14 CFR part 91…Accident 20020410007119AAirtrc AT502B · Palestine, AR(-23) On April 10, 2002, approximately 0700 central daylight time, an air tractor 502B agricultural airplane, N9074H, sustained substantial damage when it impacted a wire while maneuvering near Palestine, Arkansas. The commercial pilot, sole occupant of the…Accident 20020410005179ACessna 172S · Angel Fire, NM(.19) On April 10, 2002, at 1200 mountain daylight time, a Cessna 172S single-engine airplane, N960TA, was substantially damaged when it impacted a ditch while landing at the Angel Fire Airport near Angel Fire, new Mexico. The airplane was registered to and…Incident 20020409035729IFokker F28MK0100 · Chicago, IL(.23) Notified by o'Hare city operations of the following incident: an American airlines Fokker-100, N1411G, flight 1949, blew four main landing gear tires during landing on runway 09R at approximately 08:53 am on the 9 April 02. The aircraft landed on runway…Incident 20020409016299ICessna 172RG · Ft Lauderdale, FL(-23) The pilot lost control of the aircraft during landing on runway 08 and struck and damaged a runway edge light with the aircraft's main landing gear tire. Tower had reported wind 100 degrees at 18 g 21 and wind shear reported by a baron on final with a…Incident 20020409011779IPiper PA34200T · Holland, MI(-23) While landing on runway 05 at park Township arpt, pilot stated that while he was in the flare, approx 10 feet above runway, the plane seemed to fall hard to the surface. Nose gear collapsed and both props struck the runway.Accident 20020409009159AAerosp SA319B · Altoona, FL(-23) Mr. Thomas l. shirkey, PIC, was landing N2UH, a SA-319-B helicopter, on the landing pad located at ocala fire control center, ocala national forest, Florida. The helicopter brakes were not working and the chief pilot, Mr. Rob fulton, was standing by…Accident 20020409007739AAmtr Pietenpol · Rockycomfort, MO(-23) The pilot and passenger had departed cassville, Missouri airport (94K) for a pleasure flight in the rocky comfort, Missouri area. They were flying over property owned by the passenger's father when the accident occurred. The father stated that the…Incident 20020409007519ICessna T210N · Wharton, TX(-23) Pilot stated 2 min after departing san antonio (sat) the stall warning horn sounded. Pilot pulled the circuit breaker. On arrival to Wharton (5R5) pilot heard other traffic in the pattern, he executed a 360 to observe the other traffic. Pilot failed to…Incident 20020409005759INamer HARVARDMK4 · Corvallis, OR(-23) On 4/9/02 the PIC had completed a flight review renewal with a flight instructor. The PIC taxied to the ramp area and parked the aircraft. Completing the post flight briefing the PIC alone started his aircraft for the return flight to his home in…