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.

Incident 20021002029759IDhav DHC8102 · Albany, NY(-23) Aircraft departed alb at 10:45AM, all indications were normal during t/o phase of flt. During climb approximately 2000 MSL crew noticed an oil smell in the cockpit. Crew elected to close the #1 engine bleed valve, oil smell dissipated and captain…Oct 2, 2002 · N811AWAccident 20021002026869ABag B2062 · Dayton, OH(.19) On October 2, 2002, about 1540 eastern daylight time, a beagle aircraft b.206 basset, N72KB, was destroyed after impacting terrain in west carrollton, Ohio. The certificated airline transport pilot was fatally injured. Visual meteorological conditions…Oct 2, 2002 · N72KB · Destroyed · 1 fatalIncident 20021002026119IPiper PA44180 · Stuart, FL(-23) While taxiing after landing, the left main landing gear collapsed.Oct 2, 2002 · N142CK · Minor damageAccident 20021002025949APiper PA28161 · Norman, OK(.19) On October 2, 2002, approximately 1900 central daylight time, a Piper PA-28-161 single-engine airplane, N9623C, was substantially damaged following a loss of control while landing at the University Of Oklahoma westheimer airport, Norman, Oklahoma. The…Oct 2, 2002 · N9623C · Substantial damageIncident 20021002025779IAMD Falcon · Abilene, TX(-23) Ameristar flight 45022 (AJI022), an FA-20 aircraft, while cruising at FL310, number 1 (#1) engine indicated high oil pressure. The crew shutdown #1 engine, declared an emergency and diverted to Abilene regional airport (abi), Abilene, Texas. Aircraft…Oct 2, 2002 · N232TW · Minor damageAccident 20021001035949AWaco UPF7 · Owatonna, MN(-23) This event occurred more than two weeks prior to FSDO notification. Notification came in from a party not associated with the event and was unsubstantiated, prompting a letter of inquiry to the registered aircraft owner about the matter. All…Oct 1, 2002 · N32039 · Substantial damageIncident 20021001034579IBeech 1900D · Wichita, FL(-23) On October 1, 2002, at 11:30 local time, aircraft N13ZV main landing gear would not extend while enroute from tpa to eyw. The crew tried to extend the landing gear, but the circuit breaker popped. They reset the circuit breaker, but the landing still…Oct 1, 2002 · N13ZVIncident 20021001030769IBeech 1900D · Wichita, KS(-23) On October 1, 2002, at 20:00 local; aircraft N126YV landing gear intransit light illuminated during flight. The landing gear handle was lowered and no green indication was indicated. The crew hand pumped down the landing gear, and obtained green…Oct 1, 2002 · N126YVAccident 20021001030319APiper PA28181 · Edgartown, MA(-23) Pilot approached and landed downwind on runway 06 at Katama airport (K1B2), martha's vineyard, MA, at 1050L on 10/01/2002. Overshoot of landing resulted in an attempted pull-up, to avoid small trees beyond the end of the runway. Aircraft stalled and…Oct 1, 2002 · N8071Z · Substantial damageIncident 20021001029659IAMD FALCON50MYST · Cincinnati, OH(-23) Inflight hydraulic failure due to ruptured line part number F50B751217, rupture approx 3/16" long and approx. 1 1/2" from end. No chaffing or binding noted upon examination after replacement of line. Emerg. Gear down procedure accomplished inflight due…Oct 1, 2002 · N744XIncident 20021001029379ICleveland, OH(-23) Passenger [privacy data omitted] was operating an electrical device aboard an aircraft after being informed its use was prohibited. He also interfered with the crewmembers in the performance of their duties aboard the aircraft. [privacy data omitted]Oct 1, 2002Incident 20021001029059IPiper PA28151 · Whiterock, TX(-23) During cruise flight, engine started running rough and lost power. Pilot unable to re-establish power. Unable to reach an airport so landed on highway 2954. Maintenance personnel inspection revealed #3 cylinder exhaust valve broken. Small pieces drawn…Oct 1, 2002 · N241VUAccident 20021001028849AMooney M20J · Chicago, IL(.19) On October 1, 2002, at 1040 central daylight time, a Mooney M20J, N22RJ, collided with the terrain following a loss of control while landing on runway 18 (3,899 feet by 150 feet, asphalt) at the Merrill c. Meigs airport, Chicago, Illinois. The private…Oct 1, 2002 · N22RJ · Substantial damageAccident 20021001025919AMaule M7235C · San Antonio, TX(-23) Pilot was doing touch and go landings, when a gust of wind caused him to lose control of the aircraft. He departed the left side of runway 30 at which time he hit a drainage ditch, then a parked tow truck. The aircraft caught fire after the impact.…Oct 1, 2002 · N4269B · Substantial damageIncident 20020930031269ICessna 150M · Poughkeepsie, NY(-23) At approximately 1100 local time a Cessna CE-150 N9226U departed from runway 25 pou. During climb experienced a rough running engine, returned to pou and landed rwy 24 at 1108 local time without incident. M or d report as follow-up.Sep 30, 2002 · N9226UIncident 20020930030059ISwrngn SA26AT · Dallas, TX(-23) Return to Addison from meacham. Normal landing on runway 15 then nose collapsed. No injuries to pilot or single occupant.Sep 30, 2002 · N213SC · Minor damageAccident 20020930029989APiper PA28140 · Moorhead, MN(-23) Aircraft lost power on short final as a result of fuel exhaustion in the left fuel tank due to improper fuel management. This fuel starvation resulted in an off airport landing causing substantial damage to the aircraft.Sep 30, 2002 · N9714W · Substantial damageAccident 20020930029939ATcrafk DCO65TCRAFT · Little Falls, MN(-23) Mr. Burns hand-propped his aircraft on the ramp in Little Falls, MN., without the use of a qualified person in the cockpit or the use of chocks to secure the airplane. After the engine started, it moved under it's own power across the ramp in a curved…Sep 30, 2002 · N50107 · Substantial damageAccident 20020930028939AMooney M20E · Kutztown, PA(-23) At 1535 EST, N5556Q, an M20E, impacted the ground and exploded in a wooded area 176 feet west of runway 14 shortly after departure. Local authorities responded and reported the aircraft was on fire with the pilot inside. The aircraft was destroyed and…Sep 30, 2002 · N5556Q · Destroyed · 1 fatalIncident 20020930028409IAmtr Raptor · Deland, FL(-23) On September 30, 2002, at 1525EDT, an experimental, spearman michael Raptor, owned by spearman michael, and piloted by Mr. Diamandi j. cokinogenis, made an emergency landing on runway 12 at the Deland airport, located near Deland, Florida following an…Sep 30, 2002 · N750TP · Minor damageAccident 20020930026799AMooney M20J · Oakley, ID(-23) On September 30, 2002, at approximately 16:30 MDT, while in cruise flight from grand junction Colorado to boise Idaho, the engine lost oil pressure. The pilot attempted to get the aircraft to the nearest airport (Oakley, ID 1U6) but was unable to…Sep 30, 2002 · N4232H · Substantial damageAccident 20020930025699ARobsin R22 · St Louis, MO(-23) The CFI was giving the first flight lesson to a student. The CFI took off, flew a traffic pattern and landed to the middle of the sod runway. The CFI turned the helicopter into the wind (200 at 9 knots), and proceeded to instruct the student. The CFI…Sep 30, 2002 · N8372B · Substantial damageIncident 20020930025319IBoeing 737301 · Texico, TX(-23) On 09/30/2002, 17:25 CDT delta flight 1628, a Boeing B737 was enroute from dfw to ontario, CA. Flight was over Texico, new Mexico at time of incident. White smoke was observed coming from the forward galley area. Flames were not observed, but front of…Sep 30, 2002 · N948WP · Minor damageAccident 20020929038209ANamer AT6 · Circleville, OH(-23) The T-6 was the lead aircraft in a four ship flight at a fly-in. The formation separated for individual passes northbound along the runway followed by teardrop course reversals the flying along the runway in the opposite direction. The accident aircraft…Sep 29, 2002 · N29930 · Destroyed · 1 fatalIncident 20020929036659IPiper PA28R201T · Mount Vernon, OH(-23) Pilot failed to put landing gear extension handle in down position. Aircraft is equipped with auto gear extension with a disabling switch, the switch was in the disable position at the time of the incident and pilot failed to extend the landing gear…Sep 29, 2002 · N920DM · Minor damageAccident 20020929036069ARobsin R44 · Del Rio, TX(-23) Due to the gusting winds during helicopter trailer landing operations, the helicopter struck the trailer that it was attempting to land on. The helicopter suffered substantial damage and came to rest on its right side. The passenger sustained minor…Sep 29, 2002 · N952LC · Substantial damageIncident 20020929035829IPiper PA18 · Ekwok, AK(-23) While flying about at 700' AGL about 10 miles east of Ekwok pilot had an inflight separation of the last 18" of the propeller blade. Aircraft began to shake violently, pilot reduced power to idle, slowed down the aircraft and landed in the tundra. Upon…Sep 29, 2002 · N723C · No damageIncident 20020929035209ICleveland, OH(-23) American trans air - flight 8028 (las-cle), 7337 w. Washington st., indianapolis, in 46251. Evidence indicates that airline personnel boarded passenger,[privacy data omitted] who appeared to be intoxicated at the time of boarding and was served alcohol…Sep 29, 2002Incident 20020929032429IConaer LA4 · Poughkeepsie, NY(-23) According to personnel of Dutchess County tower, N1204L was in the pattern making approaches to runway 24. On the second attempt, the local controller attempted several times to advise N1204L that the landing gear appeared to be retracted. No response…Sep 29, 2002 · N1204L · Minor damageIncident 20020929032419ISaab SF340A · Charleston, WV(-23) Crew received master caution due to hydraulic pressure low. Crew observed pressure approaching redline. Hydraulic level was normal. Qrh procedures were called out by the PIC to the first officer to attempt to regain pressure in the main hydraulic…Sep 29, 2002 · N106XJ · Minor damageIncident 20020929031839IAmtr Glasairshii · Tucson, AZ(-23) On September 29, 2002, N84AG was landing on runway 24 at Ryan airport, Tucson, Arizona, when the right landing gear sheared off causing the right wing tip to scrape the runway. The aircraft experienced damage to the right wing tip, wheel well door and…Sep 29, 2002 · N84AG · Minor damageAccident 20020929030329ACessna 208B · Pawtucket, RI(-23) Rhode island aeronatutics commission - al moder investigated accident. Accident involving a parachutist @ north central airport (sfz) @ 1630EDT on 9/29/02. Parachutist - susan costa, [privacy data omitted] boston-providence skydiving center, overflew…Sep 29, 2002 · N9347BIncident 20020929029019ICessna 310H · Manassas, VA(-23) Pilot departed jyo at 2050Z. He heard a popping sound when he retracted the landing gear and did not get a gear up indication. He proceeded to hef where he made several attempts to lower the gear followed by low passes of the control tower to determine…Sep 29, 2002 · N1023Q · Substantial damageAccident 20020929028889ATrytek 65C · Front Royal, VA(-23) Enroute from katana airpark, ma (1B2), subject aircraft entered a left base-to-final turn for rw 09 at Front Royal airport, VA (frr). The aircraft continued in a left-wing-down turn, the pilot added power and the aircraft impacted the ground.Sep 29, 2002 · N24277 · Substantial damageIncident 20020929028419IAmtr Kitfoxiv · Deland, FL(-23) Ronald frank levee, the pilot in command and sole occupant of kit fox, N1441Z, states that he departed Deland municipal airport, Deland, Florida at approximately 08:40 EDT on September 29, 2002, for a pleasure flight in the local area. He returned to…Sep 29, 2002 · N1441Z · Substantial damageAccident 20020929028309ASwrngn SA227AC · Hawthorne, CA(-23) Investigation of the accident scene and aircraft revealed that the aircraft veered left after nose wheel steering was disengaged. The left engine propeller was found to be on the start lock at the time of impact. The right engine propeller was not on…Sep 29, 2002 · N343AE · Substantial damageAccident 20020929026809ACessna 172S · Medford, OR(-23) During a cross country flight from Medford, Oregon to caldwell id. And return, the aircraft struck mt mclaughlin at the 8700' level in cruise flgiht on the return leg. The flight was conducted under visual flight rules. No flight plan was filed. A…Sep 29, 2002 · N514SP · Destroyed · 2 fatalIncident 20020929026169ICessna 421B · Sheridan, WY(-23) While in cruise at 25,000 feet, co-pilot windscreen center portion blow out and departed aircraft. Aircraft made an emergency landing without further incident.Sep 29, 2002 · N421DK · Minor damageAccident 20020929025889APiper PA28R200 · Bayou La Batre, AL(-23) At 1642 on 29 September, 2002, N2963R, a Piper PA-28R-200, piloted by john t. gwin, departed roy e. ray airport, 5R7, near Bayou La Batre, Alabama, on the second leg of his flight from orlando, mco, to mobile downtown airport, bfm. Shortly after…Sep 29, 2002 · N2963R · Substantial damageIncident 20020929025759ICessna 120 · Spanish Fork, UT(-23) The pilot of a Cessna 120 (N1947V) was landing on runway 12 at Spanish Fork, Utah on August 29, 2002 when he lost control of the aircraft which went off the left side of the runway. As the pilot applied the brakes to stop the aircraft it went over on…Sep 29, 2002 · N1947V · Minor damageIncident 20020929025419ICessna 182P · Sun River, OR(-23) On 9/29/02 the PIC was flying at eight thousand feet on an instrument (IFR) flight plan clearance departing geg. Several miles north of Sun River, Oregon while in IMC conditions the pilot noticed freezing drizzle. The aircraft began to pick up ice and…Sep 29, 2002 · N182VCAccident 20020929025099ASnias AS350B3 · Bishop, CA(-23) During pre-take off hydraulic check, with hydraulics off, aircraft became airborne and rolled. Aircraft ended up on right side. (.19) on September 29, 2002, about 0854 pacific daylight time, a Eurocopter AS350-B3, N352SA, collided with terrain during a…Sep 29, 2002 · N352SA · Substantial damageIncident 20020929024849IAmtr RANSS12XL · Morgan Township, PA(-23) During cruise flight, aircraft experienced a loss of power. Preliminary investigation revealed the center cylinder had little to no compression. Pilot did not hold a pilot or medical certificate, and the aircraft was not registered. In addition,…Sep 29, 2002 · N5413D · Minor damageAccident 20020928032299ASchler KA8B · Tullahoma, TN(-23) On September 28, 2002, at 1130 CDT, at Tullahoma-highland rim regional airport, student pilot david a. ball piloted N8747 on his 17th solo flight. He stated that he underestimated the strength of the wind in the pattern, came in too low on final…Sep 28, 2002 · N8747 · Substantial damageAccident 20020928030629AAmtr NIEUPORT17 · St Louis, MO(-23) Mr. Jonas was on downwind when the cylinder head temperature gauge showed the engine was overheating and the engine power was decreasing. Believing he would be unable to make the runway at 1H0 he elected to land on a roadway that was under construction.…Sep 28, 2002 · N678DJ · Substantial damageAccident 20020928029949ACessna 182 · Estacada, OR(-23) The pilot, travis william marshall states: I departed OR66 at approximately 18:20 with myself and four parachutists aboard. I conducted a normal climb to 2000 MSL, contacted portland approach on 118.1, and continued to climb at 80 knots until reaching…Sep 28, 2002 · N5337B · DestroyedAccident 20020928028179ACessna 182G · Paradise, CA(-23) On 28093PDT, a Cessna 182-G, N2443R, made a hard landing at Q88, CA. Skydive at Paradise was operating the aircraft under CFR 14 part 91. The cmml PIC, the sole occupant, was not injured; the aircraft sustained substantial damage. The aircraft departed…Sep 28, 2002 · N2443R · Substantial damageAccident 20020928027689ACessna 421B · Mineral Wells, TX(-23) On September 28, 2002, at 10:45 CST, a Cessna model 421B, registration number N7926R, operated by jon anthony o'brien, commercial pilot certificate number 463270545, crashed during landing on runway 13, Mineral Wells municipal airport (mwl). The flight…Sep 28, 2002 · N7926R · Substantial damageAccident 20020928026739APiper PA28161 · Spokane, WA(-23) During flight training, aircraft made hard landing when student allowed airspeed to decay while about 10 feet in air. A/c landed left main landing gear first, then nose wheel. Post landing inspection determined damage to nose gear strut. A/c grounded…Sep 28, 2002 · N132ND · Substantial damageIncident 20020928026649IBeech V35B · Los Banos, CA(-23) On 09-28-02 at approximately 1625 PDT, Mr. Robert p. parker was acting as pilot in command of aircraft N6056Y, a bonanza V35B aircraft. He was receiving flight instruction from Mr. Lloyd e. swenson, who by agreement and due to the lack of a medical…Sep 28, 2002 · N6056Y · Minor damage