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 20040125001009IJetair JETSTM4101 · Greensboro, NC(-23) Runway braking action was reported "fair". Aircraft landed and captain was unable to select reverse on either engine, aircraft went off the end of runway 5 at gso.Accident 20040125000939AUnivar 1083 · Sanford, ME(-23) Mr. Haas the owner and pilot of the aircraft went to the aircraft aftr breakfast. He tried to start it and it stalled, tried again with no success. He waited for a moment then smelled something. He got out and looked under the cowling to find a fire in…Accident 20040125000909APiper PA28180 · Minden, NV(-23) Student pilot landed on rwy 34 at mev. Lost control of aircraft and veered off the side of the runway into muddy ground. Minor damage to aircraft, no injuries.Accident 20040125000789ACessna 172M · Girdwood, AK(-23) After a normal preflight and run up the pilot started his take off roll. As the aircraft became light on the wheels the pilot noticed that the airspeed was not working. He elected to abort the take off. The aircraft could not be stopped before…Incident 20040125000599ICndair CL6002B19 · Atlanta, GA(-23) The aircraft was taxiing northbound, inbound to C-33 on the west taxi lane. An abs pickup truck traveling west collided with the aircraft's right wing causing the pickup to be flipped onto its roof. The aircraft sustained substantial damage to the…Incident 20040125000519ICessna 172N · Stanwood, WA(-23) Mr. John m. newhoff, private pilot certificate #273883, departed Boeing field at 10:15 am on a personal flight to camino is. Airfield in a Cessna 172, N738VJ. At approximately 11:45 am the pilot used the whidbey is ATIS for his weather (winds 090/5) and…Incident 20040124019609IMooney M20C · Moultonboro, NH(-23) Mr. Frederick took off from 5M3 on 1/24/04 at about 1400 hours local for the first flight of the day. He put the flaps up and then put the gear handle up, there was no response from the gear motor. The green light stayed on and the transition light came…Incident 20040124002699IPiper PA28RT201T · Baco Raton, FL(-23) At 1316 EST on 1/24/2004, a PA-28RT-201T (t-tail Piper arrow) registration N4340G, landed gear up on runway 05 at bct, Boca Raton, FL. The pilot stated during the interview with the FAA inspector that caution to verify three green down and locked gear…Incident 20040124002409IPiper PA32260 · Eagle River, WI(-23) Aircraft landed on runway 22 at Eagle River, (egv). Left main gear was not on runway hard surface causing aircraft to veer to left. Aircraft struck 2 runway and 1 taxi light. Nose gear collapsed, belly skin, propeller and left wing were damaged.…Accident 20040124001719AUrocop EC120B · Hampton, GA(-23) While receiving instruction, ATP rated student was conducting a touchdown autorotation. During the flare, student applied additional rear cyclic, causing the tail stinger to strike the ground. As the aircraft rebounded to a nose low attitude, the main…Accident 20040124001189AGulstm 112A · Bedford, MA(-23) Pilot reported smoke in the cockpit to boston TRACON while in cruise flight at 4500 feet MSL while enroute from hya to ash. Source of smoke could not be identified initially and the pilot shut down the electrical system but smoke continued to be a…Accident 20040124000929ABbavia 7AC · Plainwell, MI(-23) He was on final approach for a touch and go landing with skiies at pine lake, allegan county, Michigan. The aircraft in front of him advised him to watch for the power line just as his ski was contacting the power line. His altitude was approximately 50…Incident 20040124000879ICessna 172N · Shiprock, NM(-23) On January 24, 2004, at 1648 MST, a Cessna 172, N5802J, registered to durango air service, incorporated, collided with power lines on takeoff at the Shiprock Airstrip, Shiprock, new Mexico, while on a cross country flight. Visual meteorological…Incident 20040124000759IMooney M20K · Bishop, CA(-23) During an interview 01-29-2004 the pilot stated he attempted to land but during the final approach just prior to touch down his attention was diverted and the aircraft "fell thru" causing the aircraft to contact the runway and then bounce into the air…Accident 20040123011189ARobsin R44 · Vero Beach, FL(-23) The pilot of N77KK was repositioning the helicopter for departure, during hover taxi the left skid hit a 2-foot high hedgerow. This impact causes the helicopter nose to pitch up and the tail rotor to pitch down. The tail rotor impacted the ground and…Incident 20040123010859IPiper PA28161 · Ft Myers, FL(-23) On January 23, 2004 at 1520Z, a Piper PA-28, N8234P, registered to beaver aviation south, collided with the VASI lights on runway 5 at Page Field, fort Myers, Florida, while a student pilot was starting a solo cross country flight. The aircraft had…Incident 20040123001599ICessna 172RG · Warrensburg, MO(-23) Mr. Foreman was taxiing the aircraft from the main terminal ramp at cmsu max b. swisher Skyhaven Airport (9K4), Warrensburg, Missouri, to the maintenance hangar (located approximately 1/4 mile s.e. of the main terminal building), when a strong wind gust…Incident 20040123001199IRawdon T1 · Fort Smith, AR(-23) The T-1, call sign. BREW21 departed vance afb to ft. Smith; BREW21 shot the ILS runway 7 and blew the right main time, BREW21 failed to stop, entered the overrun and ran off the right side of the runway overrun.Accident 20040123000849ABeech A36 · Farmington, NM(-23) On January 23, 2004, at 1916 MST, a Beechcraft A-36 bonanza, N8240U, registered to san juan pilot training, incorporated, lost power due to fuel deprivation while in the traffic pattern at Four Corners Regional Airport, Farmington, new Mexico, while on…Accident 20040123000349AAmtr T18 · Compton, CA(-23) According to witnesses interviewed at the scene of the accident, the pilot of the T-18, N64EC was landing on runway 25 right when he had to maneuver to avoid hitting a helicopter, N29LB that was also landing on 25 right. While maneuvering, the T-18…Incident 20040122035679IBeech B36TC · San Diego, CA(-23) Tire tracks show that the aircraft touched down at the intersection of taxiway "c" and runway 10 right with approximately 962 feet remaining. The aircraft departed the end of runway 10 right at approximately 45 degrees and came to rest just short of…Accident 20040122018249ACessna 182R · Ringgold, TX(-23) Dallas FSDO was notified that a Cessna 182R N9374H registered to united helicopters inc. had hit a communications tower wire while on pipeline patrol in Ringgold, Texas on January 22, 2004 at approximately 0950 hrs CST. The pilot then flew the aircraft…Accident 20040122011129APiper PA23160 · West Palm Beach, FL(-23) N4239P was fueled at Florida airmotive, inc. with 12.4 gal. Of 100LL. The a/c departed lantana airport (klna) donald dubois (PIC) and his daughter [privacy data omitted] enroute to everglades city. Witnesses stated that the a/c departed runway 27…Incident 20040122002339IAMD FALCON20 · Minneapolis, MN(-23) First officer mckinley landed the aircraft on runway 30L at msp. While clearing the runway, the crew announced to ATC that they may have blown a tire. The aircraft had cleared the runway on taxiway delta and came to rest past taxiway whisky, where it…Incident 20040122002309IPiper PA32300 · San Jose, IL(-23) On January 22 at about 1030 CST while on an IFR flight from marion IL, to peoria IL, cruising at 4000 feet the appropriately rated and qualified pilot experienced a complete engine failure. The PIC declared an emergency with pia ATCT. The PIC landed the…Accident 20040122001659ABeech F33A · Shoshone, CA(-23) Mr. Turner attempted to take off downwind on a short runway. With insufficient airspeed and little runway remaining, Mr. Turner departed the ground/runway and after take-off could not regain sufficient airspeed to remain in flight. Mr. Turner attempted…Accident 20040122001039ACirrus SR22 · College Park, MD(-23) On January 22, 2004 at approximately 10:20 EST, a Cirrus SR22, registered as N344CD, sustained substantial damage to its left wing after landing and roll out at College Park, MD (cgs). After touchdown, the pilot applied normal braking but the left brake…Incident 20040122000719IPiper PA34200T · Concord, NC(-23) Inspector's statement: on January 16, 2003 an aircraft incident occurred at Concord airport in Concord, north carolina, the following is an account of this inspector's on scene investigation. During the rollout phase from a normal landing, the right…Incident 20040122000239IMooney M20F · Bessemer, AL(-23) Nose gear collapsed during landing roll.Accident 20040121001739AAMD Falcon · Pueblo, CO(-23) Last report received from den center was 1/2 inch slush reported by pub tower on shutdown at 2200 MST. Captain itani made a low pass over the field and decided runway 08 was the best choice considering wind and runway conditions. Captain itani reported…Accident 20040121001339APiper PA32R300 · Bishop, CA(-23) On January 21, 2004, about 0845 hours pacific standard time. A Piper PA-32R-300 registered as N8701E was destroyed in the post-impact fire during a collision with terrain 16.3 miles south of Bishop, CA on bearing 335 degrees, altitude @ 5860.…Incident 20040121001149ICessna 172K · El Monte, CA(-23) The student pilot was conducting his first solo flight after several practice take-off's and landings with his flight instructor. While performing his third solo landing, the student pilot lost control of the aircraft after touching down on the runway…Incident 20040121000609IPiper PA31350 · Fort Yukon, AK(-23) [privacy data omitted] loss of engine oil pressure and manifold pressure.Incident 20040120002499IBeech 1900D · Franklin, PA(-23) Crew reported that on approach to fkl, the MLG gear down indication failed, first one light, then all four. After a missed approach, they requested and were granted clearance back to pit. During the return leg, the crew replaced the MLG indication…Accident 20040120000829ACessna 172P · Granada Hills, CA(-23) On 01/20/2004 dennis g. midden flew CE-172-P from oakland, CA, (oak) with a destination of john wayne airport (sna). Before departing oak Mr. Midden added fuel to about 3" below the filler rock. He said the fuel gages read nearly full. After taking off…Accident 20040120000269ASnias AS350B3 · Mesa, AZ(-23) While conducting a training flight in the area of ffz, the pilot entered a practice autorotation @ 1900' (MSL)/80 KIAS. The autorotation was set up straight-in @ 220 degrees to the grass area just north of the runways at ffz. The autorotation descent…Accident 20040119036269APiper PA46500TP · Minneapolis, MN(-23) During takeoff on runway 28R at fcm the pilot stated the engine shuddered and lost power. He opted to move power lever to idle and land. Pilot did not have time to extend the landing gear. Aircraft landed gear up and slid off end of runway 28R.…Incident 20040119018629IPiper PA24250 · Van Nuys, CA(-23) On 01/19/04 N7988P a PA-24-250 suffered a ldg collapse at vny. Inspector belknap from the vny FSDO inspected the damaged aircraft on 01/20/04 with the following findings: all ldg gear retract rods were straight and showed no signs of bending, all ldg…Accident 20040119011119APiper PA28181 · Fort Pierce, FL(-23) At 0106 (local) on January 19, 2004, while on an ILS approach to st. Lucie county airport, N298PA, a PA-28-181 struck trees with its left wing and crashed approximately one half mile short of rwy 9. The 90-foot trees, located 1000 feet westnorthwest of…Incident 20040119001229ICessna 152 · Haskell, OK(-23) Aircraft engine stopped operating during training. The CFI and the student were practicing chandelles. The CFI was not able to restart the aircraft engine and landed in a plowed field. Water contamination was found in gascolator fuel strainer.Accident 20040119000969ACessna 172K · Grass Valley, CA(-23) Aircraft crashed into trees 1 mile south east from Grass Valley airport fatally injuring both occupants on board (biohazard area). The aircraft was severely destroyed. No indications of fire.Accident 20040119000619ARobsin R22BETA · Nicholasville, KY(-23) On January 19, 2004, at 1430 eastern standard time, a Robinson R22 beta, N224LC, collided with the ground and was destroyed by post crash fire during an emergency landing near Nicholasville, KY. The emergency landing was precipitated by a loss of engine…Incident 20040119000429IBeech A36 · Kingston, OK(-23) Upon landing on rwy 36 at Kingston Oklahoma (F31) the aircraft struck a deer that was crossing the runway at appx 55MPH.Accident 20040118019269AAmtr RV8A · Lihue, HI(-23) On January 18, 2004 at approximately 1855Z aircraft N809RS on descent to Lihue Airport, leaving 4500FT, pilot encountered a loss of power. Pilot contacted ATC and reported his altitudes of 1000FT to 200FT all the way down until ditching into the ocean.…Accident 20040118001529ACessna P210N · Tucson, AZ(-23) Pilot stated that he had taken off from Tucson at 4:00 am enroute to Texas when he experienced a total electrical failure. He returned to Tucson, extended the landing gear by the emergency method and landed. Upon landing, the nose gear collapsed causing…Accident 20040118000339ACessna 182Q · Saint George, UT(-23) During touch and go practice procedures pilot came in too high and too fast and had a hard landing bounced in the air and then did a go around and re landed with no further incident. Investigation revealed bent propeller and bent firewall. Weather was a…Accident 20040118000329APiper PA46350P · Marine City, MI(-23) Aircraft landed on runway 04. Pilot reported that the left main gear brake was dragging. The aircraft veered to the left and eventually went off of the left side of the runway thru a snow bank collapsing the left main and nose gear. The aircraft came to…Accident 20040117011191APiper PA30 · Clearwater, FL(-23) Pilot of this aircraft (PA-30) departed winter haven (gif) at approximately 1400 local for an estimated flight of 30 minutes to Clearwater airpark (clw). Purpose of flight was to retrieve books from previous owner for this aircraft. Pilot stated he…Accident 20040117011149ACessna 182A · Traphill, NC(-23) On January 17, 2004 at 1536 eastern standard time a Cessna 182A, N4744D, registered to and operated by a private pilot Mr. Thomas john wood, crashed during an emergency landing in Traphill, north carolina. Visual meteorological conditions prevailed…Incident 20040117010689IBoeing 7272J0 · Kinston, NC(-23) On January 17, 2004 on a routine flight from bos to cancun mex at 31000, flight 8510 with 149 passengers and 8 crew members had a forward cargo compartment fire warning light come on. The flight crew followed the emergency checklist procedures. ATC was…