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.

Accident 20041102031119ARawdon T1 · Hollywood, FL(-23) On November 2, 2004, at about 1216 EST, a Rawdon T-1, N2607D, registered to and operated by van wagner aerial media LLC, as a title 14 CFR part 91 aerial advertising flight, crashed in pembroke pines, Florida. Visual meteorological conditions prevailed…Nov 2, 2004 · N2706D · Substantial damage · 1 fatalAccident 20041102029139ASnias AS350B3 · Sierra Vista, AZ(-23) The pilot was responding to an EMS call when he took-off from the designated heli-pad on the roof top of Sierra Vista regional hospital. After an approx. fifty (50) foot vertical ascent, the pilot tipped the nose of the helicopter forward to enter…Nov 2, 2004 · N106LN · Substantial damageAccident 20041102028829ACessna 120 · Willimantic, CT(-23) Mr. Mosimann was receiving dual instruction for the purpose of adding airplane single engine land to an already existing commercial pilot certificate. Mr. Vanvoorhis was the instructor and pilot in command of the flight. Mr. Vanvoorhis stated that the…Nov 2, 2004 · N1811N · Substantial damageAccident 20041102027709APiper PA24250 · Ogden, UT(-23) Aircraft was inbound for landing at the Ogden, Utah airport and had been cleared to enter left downwind for runway 34. Approximately 3 miles north of the airport the aircraft reported a problem with the engine and was cleared to land on any runway.…Nov 2, 2004 · N7852P · DestroyedAccident 20041102027319AZinair CH2000 · Salt Lake City, UT(-23) The flight was a training flight to practice basic flight maneuvers with an instructor and student pilot with about 12 hours flight time on board. The student had successfully completed 3 landings under the guidance of the instructor. On the 4th landing…Nov 2, 2004 · N8504G · Substantial damageAccident 20041102027259ACessna 172N · Columbia, SC(-23) Pilot declared mayday at approx. 00:41Z, and landed in parking. Aircraft struck power lines. Nose & main gear collapsed on landing. Major damage to aircraft caused by power line contact. Aircraft sustained substantial damage. Pilot sustained major…Nov 2, 2004 · N4874G · Substantial damageAccident 20041101029279ACessna 172RG · Kingman, AZ(-23) Pilot was unable to get the left main gear to lock down for landing. After landing gear up, inspection revealed the roller piston and bearing had fell out allowing the acuator piston assembly to re-index itself on the main gear pivot assembly. This…Nov 1, 2004 · N6140R · Substantial damageIncident 20041101027459IPiper PA60601 · Abilene, TX(-23) Aircraft departed Abilene, Texas then returned and landed without incident. The aircraft returned due to the nose landing not retracting. The nose landing gear strut was found to be low and was reserviced and ops checked good.Nov 1, 2004 · N602TEIncident 20041101027189IEMB EMB135KL · Miami, FL(-23) Flight 4350, operated by American eagle from cleveland to Miami, was descending through 15,000 feet on the approach to Miami when a large bird struck the first officer's windshield causing it to shatter, but remained otherwise in place.Nov 1, 2004 · N857AE · Minor damageAccident 20041031034219ACessna T182T · Morris, IL(-23) Pilot landed hard in a crosswind and lost control of aircraft. Wind was 260 degrees at 6 KTS gusting to 14 KTS. Pilot landed on runway 18, veered off runway and caused propeller strike with surface.Oct 31, 2004 · N814FA · Substantial damageIncident 20041031032529IFt Lauderdale, FL(-23) Passenger [privacy data omitted] interfered with the safety duties of the crew. Injury summary not known by ASI.Oct 31, 2004Accident 20041031032329ABbavia 8GCBC · Skwentna, AK(-23) The pilot [privacy data omitted] landed aircraft N86901 on an off airport location. The landing location was on a gravel bar. The gravel bar had about 8 inches of new snow on it and upon landing the aircraft nosed over causing damage to the wings and…Oct 31, 2004 · N86901 · Substantial damageIncident 20041031031999IBoeing 717200 · Rochester, NY(-23) On October 31, 2004, an airtran B-717, N927AT, registered to wells fargo bank nw na, trustee, and operated by airtran airlines, ingested a bird upon takeoff from roc. Instrument meteorological conditions prevailed at the time and an IFR flight plan was…Oct 31, 2004 · N927ATIncident 20041031031979IBoeing 7377H4 · Cleveland, OH(-23) Passenger [privacy data omitted] smoked cigarette in aircraft lavatory while in flight while "no smoking" sign illuminated and after "no smoking" briefing. Aircraft met by police. [privacy data omitted] ^ Admitted to smoking and stated the cigarette…Oct 31, 2004 · N760SWIncident 20041031031899IBbavia 7EC · Chicago/Waukega, IL(-23) Aircraft landed at Waukegan airport and lost directional control. Aircraft left the runway and stopped on airport property.Oct 31, 2004 · N9093BAccident 20041031028859AAmtr RV4 · Eagle, CO(-23) According to the pilot in command, he was VFR on top when he began to have engine problems. He declared an emergency with denver center and descended into the clouds. He estimated he broke out at 1500 to 2000 feet AGL with a visibility of 1 mile. The…Oct 31, 2004 · N25HM · DestroyedIncident 20041031028699ICessna 172S · Cedar City, UT(-23) The pilot in command landed at Cedar City Municipal Airport. During the landing run the aircraft veered off the runway and sustained minor damage. The student and CFI failed to take corrective action in time to avert the incident.Oct 31, 2004 · N576SP · Minor damageIncident 20041031028579ICirrus SR20 · Santa Ana, CA(-23) Pilot stated that he had a hard landing. He added power but hit even harder the second time, shearing off the nose gear.Oct 31, 2004 · N325Z · Minor damageAccident 20041031028419ACessna 182Q · Lebec, CA(-23) Pilot and passengers departed VFR from wm. J. fox airfield (wjf) with the planned destination of harris ranch (3O8) which was also reporting VMC. Mountains along the route of flight were however at least partially obscured in stratus clouds. After…Oct 31, 2004 · N95902 · Destroyed · 4 fatalAccident 20041031028379ABell 47D1 · San Martin, CA(-23) At approximately 0915 hours on October 31, 2004, CFI randy sharp and owner/student pilot robert seuss departed rhv (san jose) for 3O7 (hollister) with one fuel stop planned at E16 (south county airport) in a Bell 47-D1 helicopter. As the E16 airfield…Oct 31, 2004 · N903B · Substantial damageAccident 20041031027689ACessna 340A · Pensacola, FL(-23) Upon taxi and during a left turn the left main landing gear collapsed. Mechanics from the local FBO performed an inspection of the left main gear and reported that the down lock mechanism bell crank assembly had broken.Oct 31, 2004 · N340BK · Substantial damageIncident 20041031027369ICessna 140 · Laconia, NH(-23) On 10/31/2004, Mr. Caron, the sole occupant of a Cessna model 140, registration N2318N, was enroute from Massachusetts to newport, VT., his domicile airport. Due to scattered showers ahead, Mr. Caron decided to to terminate his flight in Laconia, NH and…Oct 31, 2004 · N2318N · Minor damageIncident 20041030033899ILear 25D · Ft Lauderdale, FL(-23) On runway 08 at the fort Lauderdale executive airport (fxe) on October 30, 2004 at approximately 2100 local time, [privacy data omitted] was PIC of aircraft N25UJ, a Learjet model LR-25, serial number 215, during takeoff roll, at about 80 to 90 knots…Oct 30, 2004 · N25UJ · Minor damageAccident 20041030033219ACessna P206 · Jacksonville, FL(-23) Cecil field weather (5 west of heg): calm 5BR SCT015 25/22 accident occurred during t/o on runway 11. Aircraft came to rest about 2500 ft. down and 400 ft. east of runway. Witnesses stated that aircraft was seen to climb at a very steep angle to about…Oct 30, 2004 · N2588X · Substantial damage · 1 fatalIncident 20041030032759IStbros SC7SERIES3 · Eloy, AZ(-23) During test (or experiment) of an extremely small (17.5 square foot) canopy built by precision parachute co. the right brake handle was released. Subject entered violent left hand spiral, was incapacitated by hith "g" forces, unable to gain control of…Oct 30, 2004 · N28LH · 1 fatalIncident 20041030032439IBolkms BO105S · Cameron, LA(-23) The no. 1 engine failed in flight. The pilot executed a single engine run-on landing in an open field without incident. Approximately 10 seconds after landing, the pilot reported that he saw smoke coming from the no. 1 engine compartment. The pilot…Oct 30, 2004 · N7136H · Substantial damageAccident 20041030029949AAmtr 1700RHIMAX · Hendersonville, NC(-23) This homebuilt aircraft (N105DN) took off from runway 8NC9, heading in a southerly direction. After lift off the pilot banked to the left to avoid trees at the south end of runway 8NC9. The aircraft was turning left to heading of runway OA7 in a north…Oct 30, 2004 · N105DN · DestroyedAccident 20041030029769AAmtr KR2 · Zellwood, FL(-23) Pilot reports that on Saturday October 30, 2004, at approx. 1500 hrs he landed at bob White field, aircraft bounced and pilot was unable to maintain directional control. Aircraft ran off grass runway and landed in ditch. Damage to left wing spar with…Oct 30, 2004 · N212KR · Substantial damageAccident 20041030029569ABbavia 7FC · Talkeetna, AK(-23) The pilot, acting as a certified flight instructor (CFI), was giving flight instruction for the purpose of awarding a tail wheel endorsement. When the aircraft landed, the person receiving instruction lost control and the pilot (CFR) failed to recover.…Oct 30, 2004 · N4851E · Substantial damageIncident 20041030029119IAmtr Dragonfly · Ocala, FL(-23) After flying this aircraft 400 hours with a volkswagon engine, Mr. Ufkes removed the v.w. engine and replaced it with a higher powered corvair auto engine. This engine vapor-locked after 1 minute and 30 seconds and failed. Mr. Ufkes executed a forced…Oct 30, 2004 · N88CU · Minor damageIncident 20041030028639ICamron V90 · Fulshear, TX(-23) Airman made a landing west of Fulshear, TX. And in doing so the envelope was torn by a tree during landing. The airman was counseled on the reportable requirements of the far's. no further action is required, consider this matter closed.Oct 30, 2004 · N5308H · Minor damageAccident 20041030028319ACessna 210A · Las Vegas, NV(-23) On October 30, 2004 aircraft departed the north Las Vegas airport for a local flight, as aircraft was on approach to north Las Vegas, airport @ 3500' MSL the pilot experienced a sudden engine shutdown. Pilot attempted to re-start engine with no success.…Oct 30, 2004 · N6675X · Substantial damageAccident 20041030028049ABbavia 7ECA · Summerville, SC(-23) October 30 at approximately 1710L N57388 departed Summerville Airport on runway 24 on a FAR part 91 flight. After takeoff on climb out witnesses stated that the aircraft lost power at about 500 then the aircraft made a steep left back and attempted to…Oct 30, 2004 · N57388 · Substantial damage · 2 fatalIncident 20041030027839INamer AT6C · Crestview, FL(-23) While landing on runway 17 at Crestview, Florida (cew) pilot lost directional control after touchdown allowing the aircraft to ground loop to the left side of runway. Aircraft received minor damage and no reported injuries or fatalities. [privacy data…Oct 30, 2004 · N7061C · Minor damageIncident 20041030027789IEMB EMB145LR · Louisville, KY(-23) Chautauqua airlines flight 3103 an EMB145LR, N279SK enroute from new york, NY (lga) to Louisville, KY (sdf), declared an emergency due to an engine failure. During cruise the flight crew heard a loud bang. The itt dropped to the amber range, an eicas E2…Oct 30, 2004 · N279SK · Minor damageIncident 20041030027379IBeech E18S · Wenatchee, WA(-23) At cruise from spokane, WA to Boeing field in seattle, WA, over Wenatchee, WA the pilot noticed a slight drop in oil pressure and a small increase in RPM accompanied by an increase in vibration. Pilot feathered the propeller then diverted to the…Oct 30, 2004 · N251KIncident 20041029034379ICessna 421B · Tifton, GA(-23) On landing at Tifton, GA the pilot reported hearing a loud pop. The aircraft struck the left prop and the left gear collapsed. The aircraft was removed for the runway for repair. Evidence of wavy tire marks on the runway show the left main landing gear…Oct 29, 2004 · N5431J · Minor damageIncident 20041029031599IPiper PA32RT300T · Park Rapids, MN(-23) Upon touchdown at Park Rapids airport on oct 29, 2004 in PA-32 N21436 the left main gear collapsed.Oct 29, 2004 · N21436 · Minor damageIncident 20041029030889IDoug DC982 · Roanoke, VA(-23) While at cruise, dfw to dca, with no prior warning or indication, a loud bang was heard and felt, followed by severe vibration of the #1 engine, and smoke in the cabin. The #1 engine was shut down, and the flight diverted to roa, landing without further…Oct 29, 2004 · N258AAAccident 20041029029499ACirrus SR22 · Pueblo, CO(-23) Aircraft landing runway 26R at pub. Information yankee reported winds 270/25G31. When he was landed off to tower, they gave him winds of 270/28. Normal approach until about 100 feet. At this point he had a sudden loss of 50 feet. He recovered and…Oct 29, 2004 · N203RF · Substantial damageAccident 20041029029489ACessna 185A · Skwentna, AK(-23) Pilot landed aircraft in 12 inches of snow and aircraft nosed-over causing substantial damage.Oct 29, 2004 · N185CQ · Substantial damageAccident 20041029029189APiper PA22160 · Vacaville, CA(-23) Pilot was practicing take-offs and landings after receiving several hours of dual in a tailwheel aircraft. Pilot lost directional control and ground looped aircraft. The aircraft flipped over prior to coming to rest, aircraft was substantially damaged,…Oct 29, 2004 · N8158D · Substantial damageAccident 20041029028879ADougla Adventureair · Pawtucket, RI(-23) Pilot/builder was completing the second flight of homebuilt amphibious airplane. Aircraft was flying a standard left hand traffic pattern to runway 23 at North Central State Airport, RI. Witnesses stated that the aircrasft seemed a little slow and low…Oct 29, 2004 · N469PD · Destroyed · 1 fatalIncident 20041029028799ILear 45LEAR · Pittsburgh, PA(-23) Pilot performed an emergency landing into Pittsburgh international airport after substantial hydraulic pressure drop. During inspection of the aircraft by maintenance personnel, hydraulic fluid was found covering the left engine cowling and firewalls.…Oct 29, 2004 · N742EIncident 20041029028789IBoeing 727225 · Raleigh-Durham, NC(-23) On 10/29/04 at approx 2221 local N679MG, a Boeing 727-225 aircraft was departing Raleigh-Durham airport (rdu) and was enroute to parkersburg, WV (pkb) when a fire ignited in seat 14A of the passenger cabin. The source of the fire was determined to be…Oct 29, 2004 · N679MG · Minor damageIncident 20041029028779IReims F406 · Savoonga, AK(-23) On October 29, 2004, an aircraft, Reims aircraft F406, N6590Y operated by hageland aviation services inc. and piloted by Mr. Michael james callahan, had a prop strike of a box of bolts, at Savoonga, Alaska. The aircraft was damaged to the extent that it…Oct 29, 2004 · N6590Y · Substantial damageIncident 20041029028739IEMB EMB145LR · Dubuque, IA(-23) N635AE, American eagle flight number 4053, was landing at Dubuque Regional Airport (dbq), Dubuque, Iowa October 30, 2004, when the aircraft departed runway 13. N635AE landed at dbq runway 13 during a period of heavy rain and gusty winds. The automatic…Oct 29, 2004 · N635AE · Minor damageIncident 20041029028649ICessna 172P · Westfield, MA(-23) Student was on his initial solo at Barnes Municipal Airport doing take offs and landings on runway 20. Winds were out of 190@8KNTS. On his final landing he lost control of the aircraft during roll out. [privacy data omitted]Oct 29, 2004 · N5425K · Minor damageIncident 20041029028569IBoeing 727290 · Columbia, MO(-23) Champion airlines (ccp) flight 616 was taxiing for departure on runway 20 at Columbia, Missouri (cou). Columbia ATCT cleared ccp 616 for takeoff. The captain taxied the airplane from the parallel taxiway onto runway 13 and was making a left turn onto…Oct 29, 2004 · N295ASIncident 20041029028459ICessna 172RG · Arcadia, LA(-23) CFI loftin and student chauff both advised "we just forgot to put the gear down" after completion of a simulated engine out spiraling descent from 3000' MSL to a 180 degree "accuracy" landing at the Arcadia airport (5F0).Oct 29, 2004 · N5204V · Minor damage