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 20020109000399ACessna 172N · Durango, CO(-23) Aircraft departed farmington, NM on the morning of January 09, 2002. Flew up a canyon near Durango, was unable to climb or turn around. A/c crased at approx. 1130 am local time with three (3) souls on board. Pilot received minor injuries, passengers had…Jan 9, 2002 · N3535E · No damageAccident 20020109000369ACessna 210L · Monarch, MT(-23) Pilot stated he encountered rapidly deteriorating weather conditions in mountainous terrain. During a turn initiated to reverse course and fly back out of the weather the aircraft contacted the trees on the mountainside.Jan 9, 2002 · N1713X · No damageIncident 20020108007879IPiper PA32R301T · Guthriecenter, IA(-23) Aircraft was enroute from omaha, NE, to madison, WI. The pilot reported a rough running engine and attempted to land at the guthrie center airport, guthrie center, IA. The aircraft landed in a bean field 2.5 nautical miles southwest of the guthrie…Jan 8, 2002 · N2163V · Minor damageAccident 20020108002779ABell 206L3 · Fourchon, LA(-23) Following an autorotative descent from 1200 feet altitude, the helicopter impacted the waters of the gulf of Mexico in a right, nose low attitude. Right forward emergency flotation device and the forward 41 inches of the landing gear skid separated from…Jan 8, 2002 · N349AL · No damageIncident 20020108002739ICessna T210N · Hearne, TX(-23) After takeoff, landing gear was retracted. The nose gear did not retract. The aircraft was flown by the tower at college station, Texas (cll). The tower reported the nose gear appeared not to be down and locked. Aircraft returned to Hearne, Texas (T72),…Jan 8, 2002 · N4795CIncident 20020108002559ICessna 177RG · Fallscity, TX(-23) Pilot stated that while at cruise altitude (7500 feet) the propeller over speeded exceeding red line. Engine was shut off. Pilot made emergency landing. No damage to the aircraft or property on ground. No fire, no NMAC.Jan 8, 2002 · N8244G · Minor damageIncident 20020108001379ICndair CL6002B19 · Pittsburgh, PA(-23) An atlantic southeast airlines flight #4595 suffered a hydraulic failure and diverted to pit on January 8, 2002, at 1132 local time. The CL-600 landed on runway 28R and taxied to the ramp without further incident. A pressure line and engine driven hyd.…Jan 8, 2002 · N833ASIncident 20020108000539IPiper PA60600 · Trenton, NJ(-23) Pilot stated he was flying an approach to Trenton NJ when he heard a loud bang and felt severe vibration. He identified the vibration was from the left engine and feathered the engine. He continued the approach and landed without further incident and…Jan 8, 2002 · N68918 · Minor damageAccident 20020108000419AHughes 369E · Grandcoulee, WA(-23) The aircraft was working for the state of Washington fish & game department at the colville indian reservation. The mission was to live capture deer with the use of a net gun and then attach radio collars to the animals. The pilot was flying the…Jan 8, 2002 · N369ET · No damageIncident 20020108000229IAmtr Berkut · Palo Alto, CA(-23) Aircraft incident involving N538AJ occurred at the Palo Alto airport (pao) at 1705PST on the 8th of January 2002. N538AJ was on takeoff roll for departure on runway 31 when at midfield, all three of the landing gears retracted. At this time, the…Jan 8, 2002 · N538AJ · Minor damageAccident 20020108000109ASwrngn SA227AT · Covington/Cinci, KY(-23) The aircraft was taxiing eastbound on cvg delta ramp between spot 2C and spot 3 on the north line between concourse a and b. the aircraft was approaching the ramp road that runs north and south near the west side of a concourse. The pilot observed a tug…Jan 8, 2002 · N556UP · No damageAccident 20020108000059ACessna 170B · Bellwood, MS(-23) Pilot undershot runway. (.4) on January 8, 2002, at about 1726 central standard time, a Cessna 170B, N48031, registered to the pilot, collided with the ground during an attempted landing at a Private sod airstrip near bellewood, Mississippi. The…Jan 8, 2002 · N48031 · Substantial damageAccident 20020107038479ACessna 152 · Clewiston, FL(-23) Ms. Farrel-doyle stated she is a student pilot with 40 hours. She was conducting a 14 CFR part 91 solo cross-country flight from lantana, FL (klna) to Airglades Airport (K2IS) located in Clewiston, FL. She filed a VFR flight plan and obtained a full…Jan 7, 2002 · N25441 · Substantial damageIncident 20020107005819ICessna 177 · Laporte, TX(-23) Mr. Filer "stuck" tanks with measuring ruler before take off from rwj (54T). He stated he equated 1 1/2 inch on the ruler to be a total of 1 1/2 hours fuel. He departed (54T) and flew locally over the galveston bay area for 30-40 minutes. He then turned…Jan 7, 2002 · N29643Incident 20020107002819IDhav DHC8202 · Seattle, WA(-23) On flight 2331 from lewiston Idaho to Seattle Washington crew noted noise and vibration on approach to seatac. On postflight inspection crew noted that number #1 left horizontal stabilizer de-ice boot was missing from aircraft. Maintenance removed and…Jan 7, 2002 · N367PHIncident 20020107000089IDoug MD88 · Louisville, KY(-23) During departure and climb out of cvg, delta flt. 9221 had a left air conditioning pack temperature high indication and the crew shut the left pack off. Then the right air conditioning pack shut down due to a blown duct. Passenger oxygen masks were…Jan 7, 2002 · N981DLAccident 20020106000789ACessna 414A · Sturgis, MI(.19) On January 6, 2002, at 1230 eastern standard time, a Cessna 414A, N6560C, piloted by a commercial pilot, was substantially damaged during an emergency landing on to a frozen snow covered agricultural field following a single engine missed approach to…Jan 6, 2002 · N6560C · No damageAccident 20020106000699ABeech S35 · Angola, IN(.19) On January 6, 2002, at 1756 eastern standard time, a Beech S35, N7915K, collided with the terrain following a loss of control while on final approach to land on runway 05 (4,540 feet by 75 feet, asphalt) at the tri-State steuban county airport, Angola,…Jan 6, 2002 · N7915K · No damageIncident 20020106000519IBeech 400A · Binghamton, NY(-23) The nose landing gear deployed while aircraft was descending from 190, at 280 KTS (normal gear cycle speed is 200 KTS and below). The aircraft landing gears were cycled through at below 180 KTS and with the indication of all gear down and lock the…Jan 6, 2002 · N442CWIncident 20020106000029IBlanca 1730A · Plainview, TX(-23) According to miller flying service mechanic (dewayne), the nose gear has a spiral snap ring inside the strut which is the stop for the gear strut extension. Dewayne indicated that the snap ring failed causing the nose gear strut to fully extend. This…Jan 6, 2002 · N9653E · Minor damageAccident 20020105021939ABeech 95B55 · Oakgrove, LA(-23) The pilot departed a private hunting ranch near avon, MS. Enroute to monroe, LA. (Mlu). He had received a weather briefing from deridder afss at 0825 CST for a flight from greenville, ms to monroe, LA. The briefer advised that VFR flight was not…Jan 5, 2002 · N77RY · Substantial damage · 1 fatalAccident 20020105006259ACessna T337H · Fullerton, CA(-23) On January 5, 2002 at 1259 hours pacific standard time, a Cessna T337H, N1348L crashed during the landing phase in buena park, CA. The pilot sustained fatal injuries; the aircraft was destroyed in the post crash fire. On January 10, 2002 the wreckage…Jan 5, 2002 · N1348L · No damage · 1 fatalIncident 20020105002659IMooney M20K · Dallas, TX(-23) On Saturday, 01/05/2002, a flight was initiated from rbd to Colorado springs, CO. The weather was IMC. Upon departure the tower reported that the nose gear didn't fully retract. The gear was cycled, and appeared to be down as reported by the tower. Due…Jan 5, 2002 · N231WG · Minor damageIncident 20020105002109IMooney M20E · Medford, OR(-23) On 01/05/2002 at approximately 1410 hours, pilot aborted the initial landing due to unsafe gear indication. Pilot attempted to extend gear, flew by tower, gear was not fully extended. Pilot landed rwy 9 and gear collapsed. No injuries reported. Damage…Jan 5, 2002 · N2603W · Minor damageIncident 20020105001919IBell 206L1 · Beeville, TX(-23) On January 5, 2002, at approximately 2130 daylight savings time, N2135Y received minor damage after a power loss occurred. Pitch pull on the autorotation was high, resulting in a hard landing. There was minor damage to the skid gear, a main rotor blade…Jan 5, 2002 · N2135Y · Minor damageAccident 20020105001649ACessna 441 · Riogrande, Puerto Rico(-23) On January 5, 2002, about 1423 atlantic standard time (ast), a Cessna 441, registered to alexander leasing LLC, operating as a 14 CFR part 91 personal flight, crashed while maneuvering at about 1,560 feet on el yunque mountain in the vicinity of rio…Jan 5, 2002 · N441AW · No damage · 5 fatalAccident 20020105001639ACessna 172P · Tampa, FL(-23) On January 5, 2002, at 1703 EDT, a Cessna 172P, N2371N registered to national aviation holding inc., clearwater, Florida, and was flown without authorization. The aircraft flew into downtown Tampa area and intentionally impacted the bank of americal…Jan 5, 2002 · N2371N · Destroyed · 1 fatalIncident 20020105001449IBoeing 7373T5 · Sacramento, CA(-23) After landing on roll out the aircraft slid off the end of runway 16L while attempting to turn onto taxiway D-11 at ksmf. After departing the runway the aircraft became struck in the mud.Jan 5, 2002 · N696SW · Minor damageAccident 20020105000899ARobsin R22BETA · East Troy, WI(.19) On January 5, 2002, at 0900 central standard time, a Robinson R22 helicopter, N215WW, operated by ww helicopters, sustained substantial damage when the left, rear cross tube collapsed during landing. The 14 CFR part 91 instructional flight departed East…Jan 5, 2002 · N215WW · No damageAccident 20020105000749ACessna 172K · Boulder, CO(-23) On January 5, 2002 at approximately 1600 MST, charles k. richards, pilot in command of Cessna 172, N78035 was involved in a cfit accident in day VMC and received fatal injuries. The aircraft impacted a ridge in the foothills 3 miles north of Boulder, CO…Jan 5, 2002 · N78035 · No damage · 1 fatalIncident 20020105000219ICessna T210M · Sturgeon Bay, WI(-23) Aircraft landed with landing gear retracted. Investigation revealed pilot in command failed to lower landing gear upon approach due to distraction by passenger. The landing gear horn was not heard due to the use of noise cancelling headsets by both the…Jan 5, 2002 · N2075S · Minor damageAccident 20020105000069APiper PA18150 · Reno, NV(-23) Pilot was in traffic pattern at Reno/Tahoe int'l airport to practice landing on runway 16L. On his second landing he stated that he thought he had a slight quartering tail wind (winds were light and variable). At touchdown the aircraft appeared to by…Jan 5, 2002 · N83517 · No damageIncident 20020104006739IAMD FALCON50MYST · Cleveland, OH(-23) Aircraft returned due to loss of #2 hydraulic system failure. Maintenance found #2 hydraulic system accumulator line failed.Jan 4, 2002 · N523CWIncident 20020104001569IEMB EMB145 · Dallas-Ft Worth, TX(-23) Approximately 47 minutes into the flight from mke to dfw the flight attendant, l.a. blasingame, became dizzy. The flight attendant reported this to the cockpit. The fa asked for the assistance of a paramedic who was a passenger on board. The paramedic…Jan 4, 2002 · N609AEIncident 20020104000659IDhav DHC8102 · Buffalo, NY(-23)On Friday, January 4, 2002, the captain of allegheny airlines, flight 3585, a DHC-8, N838EX, noticed sparks coming from his windshield during climb out. He then observed the windshield crack. The aircraft returned to the Buffalo niagara international…Jan 4, 2002 · N838EXAccident 20020104000379ACessna 152 · Petaluma, CA(-23) Mr. Greenberg stole the acft from aeroventure, a flight school at the Petaluma airport, and departed to the east. Witnesses stated that the acft struck a tree and burst into flames. The acft came to rest in a wooded area 1 mile south of manor road in…Jan 4, 2002 · N24223 · Destroyed · 1 fatalAccident 20020104000349AHughes OH6A · Tampa, FL(.19) On January 4, 2002, at 1505 eastern standard time, a Hughes OH-6 helicopter, N46TP, registered to the city of Tampa police department, collided with terrain during training maneuvers in a field near Tampa International Airport. The public use…Jan 4, 2002 · N46TP · No damageAccident 20020104000129AHughes 369D · Butte, MT(-23) Pilot states they were flying level at 600'-700' AGL in fine snow when the engine wound down just as if the throttle had been rolled off. Entered autorotation to median strip and hit tail first while stretching for a level surface for emergency landing.…Jan 4, 2002 · N8393F · No damageIncident 20020103038769IBeech 1900D · Jacksonville, FL(-23) On January 3, 2002, at 18:15 local time, aircraft N242YV right oil pressure guage dropped to 60 PSI after take off from jax. Crew accomplished a precautionary engine shut down, and returned to jax without further incident. Air midwest maintenance…Jan 3, 2002 · N242YVIncident 20020103005889IBoeing 757223 · El Paso, TX(-23) The passenger Mr. Robert stockburger MD, was asked to take his seat prior to the aircraft moving, then again after the aircraft started to taxi. After departure the passenger got out of his seat again and was told to be seated. The passenger went to his…Jan 3, 2002 · N642AAAccident 20020103000389ABbavia 11AC · Suttonsbay, MI(-23) He stayed high on final until crossing 50' trees at runway end. Speed was about 65 mph. He then reduced power to idle and touched down about 800' past trees and the aircraft ended up upside down about 60' past touchdown point. The left ski has a big…Jan 3, 2002 · N302AC · No damageAccident 20020102017029ABoeing 727233 · Greer, SC(.4) On January 2, 2002, at 2120 eastern standard time, a Boeing 727-200, N262FE, owned and operated by federal express, collided with an airport tug during pushback for takeoff at the Greenville-Spartanburg Airport in Greenville, south carolina. The domestic…Jan 2, 2002 · N262FE · Substantial damageIncident 20020102003009IBeech S35 · Corona, CA(-23) On January 2, 2002, at 1:20 p.m. Mr. Don challenger departed brackett field, la verne, CA. Enroute to Corona airport, Corona CA. After entering the pattern for runway 25 at Corona airport, Mr. Challenger lowered the landing gear while performing the…Jan 2, 2002 · N200BW · Minor damageIncident 20020102001469ICessna 152 · Boulder City, NV(-23) On January 02, 2002 at approximately 1424 local time (PST), N67443 a Cessna 152 (CE-152-152) had a nose wheel collapse during landing at Boulder City, Nevada (61B). The airplane was piloted by a student that was returning from a practice area for…Jan 2, 2002 · N67443 · Minor damageAccident 20020102000709ABeech 58P · Boise, ID(-23) Aircraft N132Z was doing a maintenance flight. On take-off, just after rotation, about 20 feet AGL, the pilot noticed the left engine on fire. The pilot cut power, landed and pulled fuel mixtures and shut fuel off. As of this date, 01/25/02, fire has…Jan 2, 2002 · N132Z · No damageIncident 20020102000209ICessna 172M · Kalskag, AK(-23) Pilot had just leveled at cruise flight approximately 700' AGL when engine began to lose power, sputter sporadically and reduce RPM. Pilot performed emergency procedures and set up to land on frozen lake. Pilot executed emergency landing with partial…Jan 2, 2002 · N1453V · Minor damageIncident 20020102000079IPiper PA34200 · Tacoma, WA(-23) Pilot & student pilot were conducting touch and go procedures. In the take-off phase, student pilot reached over to select flaps up but selected gear up instead of flaps up. The pilot in command saw the student pilot place his hand on the gear selector…Jan 2, 2002 · N1054U · Minor damageIncident 20020102000049IPiper PA28R180 · Henderson, KY(-23) On January 2, 2002, at approximately 2330 CST, a Piper PA-28-180 made an emergency landing resulting from separation of cowling from the aircraft. Subsequently, the cowling impacted the windshield causing it to shatter. The pilot was conducting the…Jan 2, 2002 · N4588J · Minor damageAccident 20020101005349APiper PA31350 · Ft Lauderdale, FL(.19) On January 1, 2002, about 1802 eastern standard time, a Piper PA-31-250, registered to, and operated by air taxi inc., as a title 14 CFR part 135 on demand air taxi flight, ditched in the atlantic ocean near Hollywood, Florida. Visual meteorological…Jan 1, 2002 · N3525Y · No damage · 1 fatalIncident 20020101002709IArostr RX8 · Albuquerque, NM(-23) Ms. Pholmeyer departed the 19th street ballfield on a pleasure flight with two passengers at 0800. She had flown for approximately 20 minutes and approached for a landing in a large open field that was upwind to the residence. Her intended point of…Jan 1, 2002 · N4194C · Minor damage