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 20070915021479IExtra EA300 · Apple Valley, CA(-23) The pilot was performing aerobatics maneuvers at 1200 feet when engine quit, landed on dirt road. Both main gear collapsed. When more information is available this report will be amended.Incident 20070915019619IStar, ID(-23) Experienced parachutist seemed to have become unconscious during the descent after successfully opening his parachute. He struck the ground with the main parachute fully functioning but under no control. The impact with the ground caused fatal injuries.…Accident 20070914829779ABeech A2324 · West Chester, PA(-23) Pilot performed an unsafe landing (long and fast) which required abnormally heavy braking in order to make the last taxiway at the end of the runway. While braking the left hand brake disc separated from its housing contributing to the accident.Incident 20070914824839IMooney M20K · Albany, OR(-23) While enroute IFR from imb to salem, N944Y had an engine failure. The pilot declared an emergency, switched tanks, restarted the engine. The pilot requested a diversion to Albany and landed without incident at the Albany airport.Accident 20070914023509ARobsin R22BETA · Irwindale, CA(-23) The pilot stated to the reporting inspector that he was on a demonstration flight with a prospective student pilot flying straight and level at 1700 ft. just east of el monte airport (EMT). He heard a loud report and immediately saw the alternator light…Accident 20070914023499AAirtrc AT602 · Gasoline, TX(-23) On August 8, 2007 at approximately 1340 CDT, N8225P, an air tractor 602, piloted by [privacy data omitted] impacted a terrain south of Gasoline, Texas, which is located 8 miles northwest of flomot, Texas. Pilot was intending to apply commercial…Accident 20070914023109ASavannahadv · Lava Hot Sprin, ID(-23) Pilot was practicing flying from the rt seat to improve his feel in case he instructs. The pax was a previously active pilot and his purpose was to apply brakes in which are only on the left side. The first t/o and ldg was normal. On the 2nd ldg the…Accident 20070914022299AIsrael Astraspx · Atlanta, GA(-23) The aircraft went off end of runway at pdk airport upon landing during heavy rain. The aircraft landed approx 1000 ft off end of rwy 29L and sheared off 6 sections of the localizer antenna. The landing gear collapsed and nosewheel sheared off. The right…Accident 20070914021699ACessna U206G · Fort Bragg, CA(-23) Pilot reported that he landed his aircraft on runway 16, touching down on the first 1/3 of the 1850 ft length turf runway. The aircraft overshot the end of the runway a distance of 30+ feet before nosing down an approximate 8 foot embankment adjacent to…Incident 20070914021029IAmtr Longez · Springdale, AR(-23) On September 14, 2007 at 1531 central daylight time, a rutan long-ez, registered and operated by the pilot [privacy data omitted] suffered a power loss and crashed short of runway 36 at the Springdale Municipal Airport, Springdale, AR. The airplane was…Accident 20070914020812AAmtr CASSUTT3M · Reno, NV(-23) During the Reno air race, N1VD passed N11XR slightly lower and to the right of N11XR. As both aircraft approached pylon 1 of the formula one race, N11XR started to initiate a left turn slightly earlier then N1VD and basically to the inside of N1VD. As…Accident 20070914020801AAmtr OR71 · Reno, NV(-23) During the Reno air race, N1VD passed N11XR slightly lower and to the right side of N11XR. As both aircraft approached pylon 1 of the formula one race, N11XR started to initiate a left turn slightly earlier than N1VD and basically to the inside of N1VD.…Accident 20070914018889ARobsin R22BETA · Oakland, CA(-23) Coming to a hover from a normal approach, student pilot allowed the helicopter to yaw left approximately 1 1/4 turns. Student pilot lowered the collective abruptly resulting in a hard landing causing damage to the left engine diagonal cross support.Incident 20070913825579IPiper PA31350 · Clintonville, WI(-23) On landing at cli runway 31 at approx. 1915 local airplane hit two deers with left main landing gear.Incident 20070913824929ICessna 172R · Norwood, MA(-23) The incident occurred while a certified flight instructor (CFI) was giving dual instruction to a student pilot. During a landing the CFI took the flight controls from the student to apply corrective action. A hard landing occurred causing minor damage…Incident 20070913824789ILewisj Legaleagle · Easton, PA(-23) Experimental amateur built aircraft. The owner was having some ignition problems and so decided to change all of the ignition parts. Run-up appeared normal so performed a take-off. 5 minutes into the take-off the engine lost ignition and the engine…Incident 20070913022919ILuscom 8E · Show Low, AZ(-23) While conducting high speed taxis, pilot felt a slight crosswind. He then applied his brakes resulting in the aircraft ground looping. Pilot stated that it was his error in applying brakes at wrong time. Not an aircraft accident because there was no…Incident 20070913022849IBbavia 7ECA · Saratoga Sprin, NY(-23) While taxiing out to runway 14 during light wind conditions, a bee flew out from underneath the pilot's seat. The bee landed on the pilot's face, the pilot swiped it away, at the same time applying the brakes. The bee ended up on the pilot's lap. As he…Accident 20070913022309APiper PA32R301 · Whitfield, AL(-23) The pilot departed jka direct bhm. Approximately eight miles southwest of monroeville, AL pilot made left turn direct jbr. Pilot was in contact with meridian ratcf in which they asked him if he was weather radar equipped, he replied affirm.…Incident 20070913022109IPiper PA28161 · Tucson, AZ(-23) The student pilot [privacy data omitted] was taxiing aircraft (N84245) on ramp at Ryan airport when right wing struck fuel truck. Aircraft pulled to the right after hitting truck, and aircraft propeller struck tool box that was attached to fuel truck,…Incident 20070913022099ICndair CL6002B19 · Omaha, NE(-23) N8409, a CL-600-2B19, was being operated by pinnacle airlines as flight 2936. N8409 landed with no flap indication. Contract maintenance found the flaps at 3 degrees. Powering up the aircraft the monitor showed 2 degrees of flaps. The flap handle was at…Accident 20070913021859AHughes 269C1 · Minneapolis, MN(-23) During an autorotation maneuver the tail boom struck the runway surface.Accident 20070913021399AAerovd L39C · Reno, NV(-23) During an air race, the accident aircraft attempted to pass another aircraft by descending behind, and inside, and appeared to enter wake turbulence generated by the lead aircraft. The accident aircraft appeared to enter the right (upper) wingtip vortex…Accident 20070913020909ABeech A36TC · Burlington/Mou, WA(-23) On September 13, 2007 N1811Q impacted a dense stand of trees about 1 1/2 mile nw of the approach end of runway 10 at bayview-Skagit Regional Airport (bvs), Burlington, WA. The private pilot & his 2 passengers received fatal injuries, and the aircraft,…Incident 20070913020749IAviat A1B · Grangeville, ID(-23) The pilot was landing on runway 07 at Grangeville 'S80' id. Upon roll out the pilot lost control of the aircraft. The aircraft exited the runway on the right side, proceeding into a ditch in which the right main gear struck a drainage gutter at the…Accident 20070913019489APiper J3L65 · Stow, MA(-23) The pilot reported he made one takeoff followed by a full stop landing. During the second takeoff on runway 03, he reported the engine lost approximately 50% power at approximately 100 to 130 feet. The aircraft contacted trees to the north of taylor…Incident 20070913018669ICessna T206H · Vacaville, CA(-23) Pilot stated that he went out to do a currency flight and when he landed the gear had failed to extend. The pilot then stated he observed that the circuit breaker for the landing gear had "popped."Accident 20070912831419AHiller FH1100 · Shreveport, LA(-23) The aircraft was being relocated from century Florida enroute to boulder, Nevada. The aircraft crashed and burned. The pilot and passenger sustained fatal injury. Amended report to follow.Accident 20070912831379ASchler ASW24E · Morganton, NC(-23) N24WR, a schleicher ASW-24E glider, while turning base to final, had the wing tip contact the ground causing the glider to contact the ground. This was determined to be pilot error getting too low and too slow on the approach to land. The command pilot…Incident 20070912825779IBeech C24R · Chicago/Lake I, IL(-23) The pilot [privacy data omitted] departed from Chicago executive airport, wheeling, Illinois (kpwk) at 1830 CDT. He was flying a rented Beech sierra, N5293M, from the flight school where he had conducted all his flight training, palwaukee flyers. He has…Incident 20070912023219ICessna 152 · Immokalee, FL(-23) Nose wheel separated from aircraft on landing. Wheel retaining bolt was found at the scene to have no nut or cotter pin installed.Incident 20070912022799IFreedo Phoenix · Fort Pierce, FL(-23) On September 12, 2007, at 0813 eastern daylight time, a freedom Phoenix, N11PX, experienced the loss of the nose wheel while landing, at ft. Pierce, Florida. It appears that the nose wheel axle sheared during landing. The pilot reported that immediately…Accident 20070912022719ACessna 172L · Helena, MT(-23) On September 12, 2007 at 1810 MDT a Cessna 172L N7221Q registered to sleeping giant flying club was on a landing approach to runway 27 at Helena Regional airoprt (hln) Helena, Montana. Visual meteorological conditions prevailed at the time. The aircraft…Accident 20070912022659ABoeing E75 · Gordon, NE(-23) On September 12, 2007 the pilot of a Boeing E75 stearman N68462, landed at the Gordon NE airport on runway 29. With a gusty crosswind of 10 knots off his left side, he landed and proceeded to use left and right rudder to increase his forward visibility.…Accident 20070912022629APiper PA28140 · Alsea, OR(-23) N6735J crashed approximately 1 block northeast of the parent's and grandparent's homes of right seat occupant, [privacy data omitted], a friend and CFI rated pilot of left seat occupant, [privacy data omitted]. The aircraft was recently purchased by the…Accident 20070912022619AMooney M20C · Allentown, PA(-23) After completing a solo cross country flight, the student pilot was attempting to land on runway 24 at the Lehigh Valley International Airport (abe). During his landing rollout on runway 24, the pilot stated the left wing lifted and the aircraft began…Accident 20070912022379AAmtr RV9A · Harvest, AL(-23) On September 13, 2007 the pilot made a firm three point landing damaging the nose gear then sensed a problem and pulled up and tried to land again when the nose wheel and gear dug into the ground. The aircraft ballooned upward and the pilot applied…Incident 20070912022149ICndair CL6002A12 · Tucson, AZ(-23) 15 Miles out from tus, xa-vdg's flaps failed. Upon landing tus runway 29L, the reverse thrusters did not deploy. Aircraft stopped using brakes alone, which caused the brakes to overheat. Aircraft taxied to ramp, passengers deplaned, then left main…Accident 20070912021919ACessna 180 · Englewood, CO(-23) According to the pilot he had flown from apa to salida to pueblo and back to apa. The total flight time was approximately 2.5 hours. He was given a straight in approach to runway 35R by apa, ATCT. He had properly enriched the mixture for landing. At 215…Accident 20070912021869ABell 47G3B1 · Pueblo, CO(-23) According to the pilot in command he was conducting agricultural aircraft operations, 12 se of kpub. He moved his lz to an area in a canyon. His first load was normal with a slight wind blowing from up canyon so he departed uphill and up canyon. On his…Accident 20070912020579ARobsin R22BETA · Fort Stockton, TX(-23) On September 12, 2007, at approximately 1420 CDT, the pilot [privacy data omitted] experienced an increase in engine RPM immediately followed by a decrease in main rotor RPM below 80%, in N993KC, a Robinson R-22 helicopter, manufactured in 1999. The…Accident 20070912020539ARobsin R22BETA · Long Beach, CA(-23) The pilot stated that the flight originated approximately 7-8 minutes prior to the accident. They had departed the ramp westbound, climbing left turn for mid-field crossing to pad four. The tower instructed them to pass behind a departing air carrier…Incident 20070911831589ICessna 402A · Nassau, Bahamas(-23) Due to the miami ifo failure to conduct the investigation I was assigned the investigation on January 2008. Single pilot on approach reported normal procedures. On touch down on runway with main gear, left gear collapsed causing the aircraft to veer…Accident 20070911829869ACessna 172P · Culpeper, VA(-23) At night during landing the instructor noted there was a herd of deer on the runway at Culpeper Regional Airport. Instructor informed student to do a balk landing. During this procedure the aircraft was just above the runway, and a deer jumped up and…Incident 20070911824869IPiper J3C65 · Hayden Lake, ID(-23) This incident occurred during a checkride given by an FAA inspector and is still under investigation. An amended report will be forwarded in the near future.Accident 20070911023439APiper PA18150 · Tok, AK(-23) The pilot misjudged the softness/wetness of the departure end of the dirt airstrip and was unable to get airborne. Aircraft struck tall brush and crashed into trees off the end of the airstrip. [privacy data omitted] Amendment to follow.Accident 20070911022369ABell 206B · Casey Key, FL(-23) On September 11, 2007, at approximately 1000 EDT, a Bell helicopter, model 206B, N261BH, serial #2817, was totally destroyed on impact to the surface of the water at a position of approximately 1 mile west of Casey Key, Florida. The aircraft had…Accident 20070911021379AMooney M20D · Placerville, CA(-23) On 09/11/2007 at 1955 aircraft N1229X landed gear up at pvt airport. There were no injuries reported. The aircraft received substantial damage to the belly of the aircraft. The pilot said in his report that the gear handle must not have been locked.Accident 20070911020839AAmtr Roseperegrin · Reno, NV(-23) Shortly after takeoff on runway 8, smoke was observed by personnel on the ground, coming from the engine compartment. When the pilot attempted to turn toward cross runway 32 for an emergency landing, the aircraft stalled and impacted the ground in a…Incident 20070911020669IBbavia 7GCBC · Fort Collins/L, CO(-23) A 3000 hour CFI and private rated student were on an instructional flight and in the landing phase with the intent of making a main wheel landing in a conventional geared a/c. the weather was VFR with 6 KTS of wind on the nose while landing rw 150 fnl.…