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.
Incident 20021124033489IRhnflu EA300L · Dallas, TX(-23) Pilot stated he was on approximately 1 mile final, #2 for landing at Addison Airport when he noticed a loss of engine power. Due to the congested area and limited landing areas he immediately adjusted his glide to a golf driving range, established a…Accident 20021124032779APiper PA28161 · Santa Paula, CA(.19) On November 24, 2002, about 1540 pacific standard time, a Piper PA-28-161, N2937M, collided with an automobile when it made an off airport forced landing following a loss of engine power near Santa Paula, California. The owner/pilot was operating the…Accident 20021124031879ABeech A36 · Salem, UT(-23) On VFR flight from st. george, Utah (sgu) to spanish fork, Utah (U77), aircraft crashed and burned in the foothills east of Salem, Utah. Both the pilot and single passenger received fatal injuries. A witness reported seeing the aircraft flying low…Incident 20021123037239IMooney M20J · Anderson, SC(-23) Pilot reported that right at take-off the landing gear retracted and the propeller tips nicked the hard surface runway. The pilot elected to continued the climb out and noted the landing gear switch had been inadvertently placed to the up position. The…Incident 20021123037029IMooney M20J · Anderson, SC(-23) Pilot reported that right at take-off the landing gear retracted and the propeller tips nicked the hard surface runway. The pilot elected to continue the climb out and noted the landing gear switch had been inadvertently placed to the up position. The…Accident 20021123036169AAmtr Murphyrebel · Hilton Head Is, SC(-23) Pilot lost control of aircraft upon landing and crashed into drainage ditch. [privacy data omitted]Accident 20021123035109APiper PA22108 · Coffeyville, KS(-23) Student pilot on a supervised solo made a normal approach and landing. While rolling out, student was startled by a deer. The student overcontrolled the aircraft and exited the runway. The aircraft flipped over when the nosewheel caught the edge of the…Accident 20021123034899AAmtr Velocity · Claflin, KS(-23) On the third flight of the day, at approximately 30 minutes into the flight, the aircraft was observed having higher than normal oil temperature. Due to the ellsworth correctional facility being directly south of runway 17 the PIC decided to head for…Accident 20021123034179APiper PA23250 · Stalwort, MI(-23) Pilot stated that he lost power on the left engine as it began to surging. Pilot elected not to feather engine and made a forced landing in a field causing substantial damage to the aircraft. On scene inspection revealed that the left inboard fuel tank…Accident 20021123033839AAmtr Dragonfly · Clackamascounty, OR(-23) Jeffrey m. peterson departed mulino (4S9) airfield. Mr. Peterson climbed to 2400 MSL for engine and aircraft phase I tests. He began a clearing turn for approach to mulino and descended to 1600 MSL when his engine failed. He tried to restart the engine…Accident 20021123033299ACessna 172G · Stow, MA(-23) Aircraft clipped trees on landing runway 30 at Stow and landed short of the runway. The two people on board were not injured. The latest surface observation at the time of the incident was taken at bed. The METAR at bed at 231756Z reported the winds at…Incident 20021123032089IDhav DHC8202 · Portland, OR(-23) On approach to pdx, landing gear handle was selected down and indicated three red (unsafe) lights. Gear did not come out of the wheel wells. Crew performed a missed approach and complied with alternate gear extension procedure. Gear indicated three…Accident 20021123032009AAmrgen AA1C · Rigby, ID(-23) Departed Rigby, ID airport and lost power during climb out. Applied carb. Heat and power improved. Attempted to return to airport and force landed in a field. No injuries to the solo pilot. The aircraft sustained substantial structural damage to the…Accident 20021123030639ACessna 172K · Paintsville, KY(-23) Cessna 172, N719G departed 316 airport, Paintsville, KY at approx. 1500 local time on instructional flight. During cruise flight, the engine quit due to mechanical failure. Pilot made emergency landing in a field. The airplane received substantial…Incident 20021122038539ISwrngn SA227AC · Ft Lauderdale, FL(-23) On November 22, 2002 about 1904 EST, swearingen SA-227-AC, N227FA, operated by lynx air international, inc., piloted by stonn desrosiers (PIC) and fernando g. rodriquez (f/o), veered off the runway, during landing roll, and experienced a collapse of the…Incident 20021122036599ICessna 208B · Indianapolis, IN(-23) Aircraft landed long on a 11,000 foot runway and taxied over the end of runway lights causing prop and nose gear damage to the airplane.Incident 20021122036439ICessna T210L · Joliet, IL(-23) Aircraft was a CE-210, N11KR, ser# 21061249. After the pilot selected the landing gear down the nose landing gear (NLG) did not extend forcing the pilot to land with the NLG in the unlock and up position.Incident 20021122036119IDhav DHC6200 · Lake Wales, FL(-23) Attachment ot incident number S-234 that occurred on November 22, 2002, at Lake Wales, Florida involving a sky dive from aircraft N226CS, a DHC-6 twin otter. Mark karl gabriel piloted the aircraft. Witnesses on the ground, after hearing a loud noise…Incident 20021122035299ICessna 310R · South Bend, IN(-23) Pilot stated that while taxiing during limited visibility and blowing snow that he taxied off of the taxiway and struck a taxi way light with right prop.Incident 20021122034719IRobsin R22BETA · St Louis, MO(-23) Student pilot was on a supervised solo. His flight instructor was daniel Louis neunebel, holder of flight instructor certificate number 496508667. The CFI and student pilot hovered to the north practice area of the airport together. The CFI got out of…Incident 20021122034709IPiper PA28R200 · Omaha, NE(-23) On 11/22/2002 approximately 1321 cmt Piper PA28R-200, N3928X, aircraft while inbound to Omaha declared an emergency due to full open throttle. The aircraft was able to land without incident and was towed to elliott aviation inc. of Omaha for repairs.…Incident 20021122033409IIsrael 1125 · Soldotna, AK(-23) Pilot departed anchorage and arrived at Soldotna prior to airport opening with no on site airport conditions available. Pilot made 29000' fly by and landed. Subsequent landing, aircraft departed end of runway 25 due to ice. Minor damage to left MLG door.Accident 20021122033139AEnstrm F28C · Morrison, CO(-23) Pilot was attempting a landing at a helipad located at the fort restaurant in Morrison, CO. On approach the pilot was unable to distinguish the flag on top of the restaurant which he had intended to use for wind direction indication. Pilot initiated a…Accident 20021122032799AWSK M18A · Bigthicket, TX(-19) On November 22, 2002, approximately 0900 central standard time, a Wsk pzl mielec M18A single-engine agricultural airplane, was substantially following a forced landing after experiencing a partial loss of engine power near big thicket, Texas. The…Accident 20021122031969ABell 212 · Longview, WA(-23) During hover operation main rotor blades struck top of tree causing damage to both blades.Incident 20021122031849ICessna R182 · Scottsdale, AZ(-23) Pilot was attempting to land on runway 21. During touchdown the aircraft bounced to the left. The pilot initiated a go around. During go around aircraft hit a runway light. No damage to aircraft and no injuries.Incident 20021122031729INamer T28B · Lincoln, CA(-23) During instruction flight the pilot failed to lower landing gear at Lincoln airport. Owner/pilot is an loa holder for the aircraft make & model. The pilot and instructor was not injured. The pilot stated that he was distracted by activity near the…Incident 20021122031669IAirbus A319114 · Boise, ID(-23) Northwest airlines flight 1276 ingested bird into right engine duringclimb over departure end of runway 10L. Aircraft returned and landed without incident at 1515Z. Inspection revealed extensive damage to right engine fan blades.Incident 20021122031549IBeech 1900D · Pittsburgh, PA(-23) Air midwest #5533, BE-1900, struck wingtip of a N60MJ, colgan air (nsva), a parked BE-1900 breaking the strobe light lens on both aircraft. Amwa 5533 was departing the ramp for departure. A/c was being marshalled with a right turn. PIC made left turn…Incident 20021121037279IMooney M20M · Rochester, NY(-23) On 11/21/02 pilot did a gear up landing at the Rochester international airport. Pilot stated he had lowered the gear and started thinking about the recent accident the week before in the same location so he raised the gear just in case he had some…Incident 20021121035549IMaule M5210C · Custer, SD(-23) Pilot ground looped during takeoff. After rolling about 100 feet, airplane made hard left turn and ended up in grass adjacent to runway. Damage to right wing tip, right aileron and landing gear strut. Pilot was not injured. Pilot had experienced landing…Incident 20021121035499IAirbus A319131 · Chicago, IL(-23) On November 21, 2002 united airlines A319 aircraft, registration number N804UA departed o'Hare international airport on flight 603 but returned shortly afterwards to the field and landed on runway 4RIGHT, due to a nose landing gear malfunction. The…Incident 20021121034839ICessna 402B · Miami, FL(-23) Pilot stated he became disoriented during taxi due to the construction lights and impacted runway lights at the end of runway 30 with the left propeller.Incident 20021121033579ICndair CL6002C10 · Dallas-Ft Worth, TX(-23) American eagle flight 3887, on nov. 21, 2002, departed dfw airport on runway 36R at 0812 CST. Shortly after takeoff and before being handed to departure control, declared an emergency with smoke in the cabin. The flight elected to stay with dfw tower,…Incident 20021121033219ICirrus SR22 · Covington, LA(-23) The pilot experienced an engine failure while in cruise flight. Pilot attempted an emergency landing at (L31) abita springs, Louisiana. Pilot over shot the end of the runway, no damage to aircraft, no injuries.Accident 20021121033059AAmtr Lancairivp · San Antonio, TX(.19) On November 21, 2002, approximately 1030 central standard time, a ramsay Lancair iv-p, experimental homebuilt single-engine airplane, N222MR, exited runway 30 and struck a fence at the Kestrel Airpark Airport, near bulverde, Texas. The airplane was…Incident 20021121032859IPiper PA44180 · Long Beach, CA(-23) Aircraft was on a part 61 training flight. The student was receiving dual instruction for the ATP rating. During a normal landing and after the nose wheel had touched down on runway 30 at lgb, the nose gear collapsed after a few seconds. All gear…Accident 20021121032769AAmtr EXEC162F · Monterey, CA(.19) On November 21, 2002, at 1640 pacific standard time, an asmus exec 162F experimental helicopter, N162LC, rolled over during an autorotative emergency landing on the beach in Monterey, California. The pilot operated the helicopter under the provisions of…Incident 20021121032449IMooney M20R · New Orleans, LA(-23) Pilot inadvertently retracted landing gear while aircraft was on takeoff run. [privacy data omitted]Incident 20021121031679IAmtr RV8 · Puyallup, WA(-23) When landing at Thun field, the pilot experienced a loss of directional control and the aircraft exited the runway to the right. Pilot regained control and began to parallel the runway. With limited field of vision over the nose, the left main gear hit…Incident 20021120035409ICessna 525 · Springfield, IL(-23) [privacy data omitted] in cruise 50 miles nw of kspi, battery overtemp light illuminated. Crew followed AFM procedures and turned the battery off. The light went out but came back on a few minutes later. Crew declared an emergency and diverted to kspi…Accident 20021120034919ARobsin R22 · Stjacob, IL(-23) This was a dual instrument training flight operated in VMC conditions departing st. louis downtown airport (cps) enroute to st. louis regional airport (aln) to practice instrument approach procedures. The aircraft was in level cruise flight at 2500 MSL…Accident 20021120034319AAirtrc AT502 · Joneboro, AR(-23) On November 20, 2002 at approximately 13:30 CST, a AT-502 tractor, N502RS, was substantially damaged during take off from the keller flying service private air strip, south east of jonesboro, Arkansas. The aircraft is owned and operated by craig keller…Incident 20021120033469ICessna 441 · Sidell, LA(-23) Pilot landed at Slidell Airport at Slidell, Louisiana. Upon roll-out, aircraft encountered two deer, split both deer and hit both deer with propellers. Aircraft did not sustain any damage to the fuselage, but damaged propellers. (Uncontrolled airport).Accident 20021120032789ACessna T210L · Williams, AZ(.19) On November 20, 2002, about 1610 mountain standard time, a Cessna T210L, N59132, made a precautionary off airport landing near Williams, Arizona, after experiencing smoke in the cockpit. The airplane was subsequently destroyed in a collision sequence…Accident 20021120031999ACessna 210L · Kentwood, LA(-23) Pilot reported engine problems to houston center, center was trying to vector the aircraft to a grass strip (hurst) when the aircraft struck a row of pine trees. After further investigation it was determined that the engine threw 2 rods causing the…Accident 20021120031979APiper PA28R201 · Tooele, UT(-23) During touch & go ground roll, student pilot selected gear rather than flaps up. Right main and nose landing gear retracted, the right wing and nose settled onto runway, and the aircraft skidded to a stop off the right side of the runway, taking out one…Incident 20021120030999IBeech A24R · Elko, NV(-23) On landing roll out runway 23 Elko, NV, the pilot noticed a shimmy in the nose gear. A small amount of right rudder was initiated by the pilot to keep the aircraft straight down the runway and the nose gear collapsed. No injury to the 3 souls aboard.…Incident 20021119037439IBeech V35B · Titusville, FL(-23) Pilot stated engine lost power, continued to turn. He switched tanks, used boost pump, but engine would not develop power. He elected to land on I95 with gear up, and slid into grass. Post incident investigation could find no problem with engine. It…Accident 20021119036209AAmtr Express · Moncks Corner, SC(-23) On November 19, 2002, about 1655 eastern standard time, a homebuilt Express, N297JH, registered to industries unlimited, inc., crashed into lake moultrie, near Moncks Corner, south carolina. Visual meteorological conditions prevailed at the time and no…