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 20060621013229IGulstm GA7 · Orlando, FL(-23) Nose wheel bearing disintegrated due to lack of maintenance and lubrication. Recommended inspections on this and other aircraft operated by owner.Incident 20060621013199ICessna R182 · Miami, FL(-23) Airman stated he was conducting takeoffs and landings to satisfy FAR recency of experience requirements and failed to extend the landing gear on the first landing.Incident 20060621012759IPiper PA46310P · Olathe, KS(-23) Upon landing on runway 18 at new Century Aircenter (ixd), Olathe, Kansas, the aircraft went off the left side of the runway and the nose wheel collapsed. The pilot and two passengers (both certificated pilots) reported that touchdown on the main landing…Accident 20060621012659AUnivar 415C · Panacea, FL(-23) On June 21, 2006, at 2145 EDT, a Ercoupe model 415-C, N99355, piloted by [privacy data omitted] crashed short of landing at Panacea municipal airpark (2J0) and burned at the scene in Panacea, Florida. The pilot was taking a night pleasure flight with a…Accident 20060621012599ACessna A185F · Bettles, AK(-23) [privacy data omitted] on the second attempt to take off the pilot got the aircraft airborne and could not clear the tree line at the end of the lake. At this point the pilot turned down wind to get to lower terrain. The pilot reported that he did not…Accident 20060621012279ACessna 182M · Fairbanks, AK(-23) The pilot [privacy data omitted] stated that during takeoff (at rotation) his seat slid back, causing him to overrotate and lose directional control. Aircraft then settled back onto the water and exited the float pond to the left (north) and struck the…Incident 20060621010739ICessna 172B · Anna, TX(-23) Inspector's statement: my name is [privacy data omitted] I am employed as an aviation safety inspector by the federal aviation administration, southwest region, dallas flight standards district office, dallas, Texas 75235. As the accident standby person…Accident 20060620030979ADoug DC983 · Chicago, IL(-23) On June 20, 2006, American airlines aircraft, N961TW a DC-9-82, on a flight from los angeles, CA (lax) to O'Hare international airport (ord), Chicago IL, declared an emergency due to the fact that the nose landing gear would not extend out of the nose…Incident 20060620021719IPiper PA22150 · Roanoke, VA(-23) Pilot was doing touch and gos when the aircraft hit a sink rate. The pilot bounced landing with minor damage to nose gear.Incident 20060620015669ICndair CL6002B19 · Minneapolis, MN(-23) On approach into Minneapolis saint Paul airport flaps failed at 23 degrees. Aircraft landed safely without further incident. Maintenance was performed by pinnacle airline technicians and aircraft continued service.Incident 20060620015239ICessna 421A · Columbus, OH(-23) Aircraft N216WA was cleared to land on runway 28L at cmh. On landing rollout, PIC stated the left wing started to settle and dip. The left main gear collapsed and the left wingtip and propeller contacted the runway. Inspectors [privacy data omitted]…Accident 20060620014699AAmtr RV6A · Hesperia, CA(-23) Aircraft landed downwind on runway 03, ran off the end of the runway, hit a downed telephone pole, and came to rest upside down.Accident 20060620014129AFantas ALLEGRO2000 · Sanford, NC(-23) The pilot (a student pilot with solo endorsement) set up for landing at Sanford-lee county airport (tta). On final approach for the airport the pilot stated that he felt the aircraft was high and slow. This resulted in a hard landing which caused the…Accident 20060620014069ACessna 172F · Marietta, OK(-23) On 06-20-06 at approximately 7:20 p.m. local time, a Cessna 172, N8649U, was crashed and destroyed shortly after take-off from magehee Restaurant's grass strip, near Marietta, Oklahoma. The private pilot, [privacy data omitted] elected a takeoff from…Accident 20060620013389AAyres S2RT34NORMAL · Colt, AR(-23) Aircraft was accomplishing agricultural spraying operations near Colt ar. Aircraft contacted the ground with the right wingtip while in a turn and appears to have cartwheeled into a clump of trees at the edge of the field. The pilot was fatal, the…Incident 20060620013319IAmtr VANSRV6 · Riverside, CA(-23) During taxi to his hangar, the pilot [privacy data omitted] left wingtip hit the airfield fence near the airfield tower parking lot. He continued to taxi to his hangar and shut down the engine. No injuries to the pilot [privacy data omitted]Accident 20060620013279ABeech A36 · Sonoma, CA(-23) Aircraft was found by the civil air patrol parked on the side of the airport at Sonoma skypark Sonoma, CA propped up on a bucket and covered with a tarp. An ELT signal had been going off for five hours. The nose gear appeared to have collapsed and the…Incident 20060620013139ISaab 340B · Bemidji, MN(-23) Right hand intake hot light annunciator light illuminated while in flight from Bemidji (bji) to minneapolis (msp). Aircraft returned to bji. Inlet heat was deffered under MEL 30-20-1-1(b). Right hand inlet was replaced upon arrival at msp maintenance…Accident 20060620012539APiper PA24250 · Moravian Falls, NC(-23) The aircraft was enroute from Florida to Ohio. While over the area of wilkesboro, NC the pilot reported over the emergency frequency that he had run out of fuel and was going down. An emergency landing was attempted in a field approximately 3 miles…Accident 20060620012249AHughes 369D · Salt Lake City, UT(-23) While lifting a sling load consisting of a 430 pound air ventilation van to the roof top of a window manufacturing plant the aircraft experienced a loss of power and landed on its side on the roof. The aircraft was hovering at approximately 90 feet…Incident 20060620010639ISwftms GC1B · Denver, CO(-23) Pilot was receiving instruction from cfi/atp. Pilot made uneventful landing rwy 35. As pilot turned left off of runway onto taxiway, left side of left foot became temporarily wedged between rudder pedal and side paneling. Pilot reacted to try to free…Accident 20060619029349ACessna 182N · Cooperstown, ND(-23) Pilot was landing and stated it was a crosswind about 90 degrees to landing runway. The aircraft veered off to the side and one wheel got into the tall unmowed grass. The pilot stated it pulled him in further which attributed to the further loss of…Incident 20060619023239ICndair CL6002C10 · Roanoke, VA(-23) The crew diverted and landed on runway 24 due to a loss of cabin pressurization during cruise flight. Maintenance personnel determined that a pressurization controller was defective.Incident 20060619021609IEMB EMB145LR · Albany, NY(-23) On 6/19/2006, expressjet flight 2075 enroute from buffalo to newark started an initial descent when approximately 25NM south of Albany, NY the pilots began to smell a burning odor and saw smoke coming from the bottom of #2 windscreen. The captain…Accident 20060619012629AChris A1 · Mcgrath, AK(-23) The airplane nosed over while landing at a remote mining strip. (-23 amendment) according to the pilot, he was attempting a wheel landing on an airstrip that was wet. When the main wheels touched down he applied too much braking and the aircraft nosed…Incident 20060619010589ICessna 172S · Midland, TX(-23) On June 14, 2006, the student pilot took off from runway 16 at the Midland air park airport, in Midland, Texas, to perform a solo flight in the traffic pattern and make a full stop landing. The winds were 180 degrees at 11 knots gusting to 14, 10…Accident 20060618030489AScwzer SGS233A · Hood River, OR(-23) Pilot was flying the schweitzer sgs 2-33A glider approximately 5 miles east of the Hood River airport in some ridge soaring conditions. The wind blew the glider downwind of the ridge into some striking conditions. Given the sink and approximately 20…Accident 20060618026962AAmtr VANSRV8 · Peru, IL(-23) On June 18, 2006 a group of four aircraft departed the poplar grove airport (C77) for a flight to the Illinois valley airport in Peru IL (vys). Prior to departure the group had a preflight briefing discussing the planned diamond formation flying to take…Accident 20060618026961AAmtr RV6A · Peru, IL(-23) On June 18, 2006 a group of four aircraft departed the poplar grove airport (C77) for a flight to the Illinois valley airport in Peru IL (vys). Prior to departure the group had a preflight briefing discussing the planned diamond formation flying to take…Incident 20060618026289IUnivar F1 · Mifflintown, PA(-23) CFI conducting bi-annual flight review. Pilot receiving bi-annual flight review landed short of the asphalt on runway 26 at Mifflintown Airport. Minor damage to landing gear. CFI reported everything normal on approach to the runway. Aircraft sank just…Accident 20060618022649ACessna 150K · Shelton, WA(-23) At approximately 1820 PDT on June 18, 2006, private pilot [privacy data omitted] and 19 year old daughter, were flying back from ephrata Washington (eph), with an intermediate stop in ellensburg Washington (eln). The aircraft was a Cessna 150K, N6255G.…Accident 20060618018719ACessna 180 · Payson, AR(-23) The accident aircraft arrived at a dirt strip known as red creek and made a low (150' AGL) and slow pass from east to west into rising terrain with the flaps partially down. After passing over the runway the aircraft made a right 180 degree turn back to…Incident 20060618015479ICessna 152 · Cincinnati, OH(-23) On 06/18/2006 at 11:02 am local, the pilot [privacy data omitted] was on his 3rd touch and go at Blue ash airport, OH. During the landing he bounced the aircraft and at the same time encountered a crosswind of approximately 14 to 22 KTS, which carried…Incident 20060618014549IBeech G18S · Fayetteville, NC(-23) The aircraft landed on runway 36 as it slowed down and the tail wheel touched the runway, the aircraft drifted to the left, the pilot added full right rudder and brake to try and stop the drift, the aircraft exited the runway into the grass between the…Accident 20060618013379ACessna 180 · Great Falls, MT(-23) Pilot tried to take off with a quartering tailwind. The aircraft wheels lifted off, then the aircraft veered to the left, and the left wing hit the ground. The landing gear collapsed and the propeller hit the ground.Incident 20060618013309ICndair CL6002B19 · Wichita, KS(-23) On June 18, 2006, pinnacle airlines flight 2826, at 1455 local time, aircraft N8775A while enroute from minneapolis Minnesota, to Oklahoma city, diverted to Wichita Kansas, because of hydraulic problems. The pilot report states that the aircraft was…Accident 20060618012499ACessna A185E · Dillingham, AK(-23) The pilot on takeoff from an off-airport beach hit a set net rope by the main gear of the aircraft causing the aircraft to nose over onto its back causing substantial damage.Accident 20060618011939APiper PA28140 · Louisville, KY(-23) Per pilot's statement: "at approximately 4:00 pm on June 18, 2006 I received vectors from lou approach to 07KY "Blue Lick." The weather was VFR with 5 to 6 miles visibility, ceilings were about 2500 to 3000 ft. I entered downwind for a normal left hand…Accident 20060618011829APiper PA22135 · Nebraska City, NE(-23) During roll out after uneventful landing the tailwheel commenced to shimmy and shake. Pilot added power and attempted to lift tail to relieve the tailwheel shimmy/shaking. This aircraft has dual-puck disc brakes which are extremely powerful, combined…Accident 20060617030529ACessna 180 · Agness, OR(-23) Pilot attempted to reverse course in a canyon on the rogue river, OR. So he could land on a oneway out private grass strip at half moon bar lodge. During the maneuver his right wing struck a fir tree. The pilot lost control and impacted rocks along the…Accident 20060617029759ABoeing 767322 · Washington, DC(-23) On June 17, 2006 about 1525 eastern daylight time, a Boeing 767-300, N653UA operating as united airlines flight 395 was substantially damaged when it was hit by a baggage cart at the Washington Dulles International Airport (iad). The seven crew members…Incident 20060617024859IPiper PA28235 · Lapeer, MI(-23) While attempting to land on runway 27 (grass), pilot reported that the aircraft would not settle. At approximately 62 knots IAS she decided to add full power, but the aircraft apparently stalled at the same time. The aircraft then contacted the ground.…Accident 20060617022279ATcrafk DC65TCRAFT · Spenceport, NY(-23) On Saturday, June 17, 2006 at 1202 EDT, a Taylorcraft DC-065, N50VS, owned by rochester waterwings, inc. and operated by the pilot [privacy data omitted] , during takeoff from a grass strip on a southerly heading, cleared some power lines on the Road,…Accident 20060617021879AEirvon PIK20E · Carlisle, PA(-23) Pilot lost lift in a steep (full flap 90 degree) bank, while in a turn to a landing field. The field was a hay field in the vicinity of the Carlisle Airport, Carlisle, PA. The aircraft landed in trees and contacted a powerline. Aircraft substantially…Accident 20060617016099AAmtr Rotorwayexec · Mooresville, IN(-23) Upon arrival at the accident site of 1181 west state road 39, Mooresville, IN, the aircraft was destroyed by fire. The instructor/pilot was giving dual instruction to the experimental helicopter builder and it was in phase I certification. The…Incident 20060617015679IWthrly 620B · Britton, SD(-23) On June 17, 2006, the pilot [privacy data omitted] was operating N90036, weatherly 620-B, near Britton, SD. Upon climbing from field/spray run, pilot was distracted by vehicle/or traffic on the road. The sun was in front of him and aided in obscuring…Accident 20060617014039ACessna 182F · Beverly, MA(-23) Cessna N830W, piloted by [privacy data omitted] , was cleared to land on runway 27 at bvy. Wind was 230 at 11 knots. Upon landing the nose gear collapsed causing substantial damage to the aircraft. Neither the pilot [privacy data omitted] nor his wife,…Incident 20060617013269ICessna 182K · Bozeman, MT(-23) Parachutist jumped out of the aircraft and went unconscious on the descent. When he hit the ground, he landed on some farm implements.Incident 20060617013249IPiper PA31325 · Pontiac, MI(-23) On June 17th, 2006, N824AB Piper PA-31 departed jackson county airport enroute to Pontiac mi. The pilot also had his wife as a passenger in the right seat. After some discussions with his wife about her being capable of landing the aircraft in case the…Incident 20060617013179ICessna T210N · Empire, NV(-23) At 10:50 PDT, the pilot reported that he was approaching the dry lake bed for a fly-by inspection with the flaps down and the landing gear up, intending to fly a full circular pattern and then land. He then saw a truck driving along the edge with no…