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 20070119001779ICndair CL6002B19 · Richmond, VA(-23) On 01/19/07 at 1135EST comair flight 5385 diverted and landed on runway 34 after reporting a number 2 hydraulic system failure while enroute from laguardia, NY to charleston, SC. The aircraft taxied to the ramp without further incident. Maintenance…Incident 20070119001349IWalnut Ridge, AR(-23) Duece 03 had navigational problems due to an equipment malfunction at the arg VORTAC while round robin to bad, conflicting with FDX941. ZME-ARTCC-74 gave instructions to fdx 941 to turn to a heading of 360 to avoid duece 03 and duece 03 was given an…Incident 20070119000729IBeech 95 · Arlington, TX(-23) On January 19, 2007, at 2250 UTC, Beech 95 travelair registration #N13AW, owned by [privacy data omitted] . A VFR flight plan filed. During an instructional flight, where overcast and light rain conditions prevailed, the landing gear failed to deploy…Accident 20070119000369ABell 206B3 · Springville, CA(-23) The helicopter was operating in mountainous terrain under contract to the state of California department of fish and game conducting low level wildlife surveillance. The pilot reported that he was at an approximate altitude of 30' to 50' above ground…Accident 20070118001499AAmtr Searey · Danbury, CT(-23) The pilot reported that during the landing roll the left main landing gear collapsed. Preliminary examination of the left main landing gear system disclosed that the hydraulic cylinder bottom attach point (fork) broke. (-23 amendment) on 02/20/2007,…Incident 20070118001419IDhav DHC8311 · Charlottesville, VA(-23) 01/18/2007, At 1137E, piedmont airlines flight 4339, a DHC-8-311, diverted to cho and landed on runway 21 after reporting an electrical fire in the cockpit. The flight departed from philadelphia airport, pa and was enroute to roanoke, VA when the…Incident 20070118000989IBeech B200 · Oklahoma City, OK(-23) Pilot selected gear down during approach to rwy 35R at okc. Gear indication did not show down and locked on both main gear. Pilot did a fly-by the tower and tower said both gear appeared to be down. Pilot departed traffic pattern and attempted to cycle…Incident 20070118000589ICessna T303 · Des Moines, IA(-23) The aircraft departed ankeny, Iowa (ikv) for fort dodge, Iowa (FOD). The pilot indicated that he hit something on takeoff. When retracting the gear, the red indication light would not go out. The pilot wanted to land at the Des Moines, Iowa airport…Incident 20070118000329ICessna 560XL · Snyder, TX(-23) On January 18, 2007, at approximately 2045 local time, upon landing roll out, the aircraft struck a small deer that ran across the runway. The right main gear door was torn from aircraft resulting in minor damage. No other damage was sustained.Accident 20070117001539ABalwks FIREFLY9B15 · Phoenix, AZ(-23) Pilot was attempting to land and stated he encountered a downdraft during approach and subsequently made a hard landing. When the balloon collided with the terrain one passenger was ejected and sustained serious injuries.Incident 20070117001389IPiper PA44180 · Santa Barbara, CA(-23) While on an IFR flight, the aircraft encountered turbulence at 10,000 feet MSL, and had an uncommanded 300 foot descent.Accident 20070117001329ACessna 182R · Waltman, WY(-23) Plane departed gcc, never arrived at destination. Aircraft was found in a field via ELT 40 miles east of riw. The aircraft struck terrain and was completely destroyed.Accident 20070117000899APiper PA28180 · Centennial, WY(-23) The pilot departed vacaville, California, at approximately 11:00 LCL after obtaining a fss briefing from mcminnville afss for a proposed 13 hour VFR flight to grand island, Nebraska. Enroute fueling stops were in elko, NV and rock springs, WY. The…Incident 20070117000479IAmcnlg AL3 · Prescott, AZ(-23) The pilot [privacy data omitted] was flying his legend cub, N1115, on 01/17/2007 on a sightseeing flight. Upon returning to prc he was cleared to land on runway 21L. He cleared at taxiway C4. The tower controller issued an immediate stop to N1115 and…Accident 20070117000449ADoug C54GDC · Nenana, AK(-23) [privacy data omitted] aircraft was enroute at 2500' to Nenana with 7 bladders of heating fuel (3000 gal) #2 engine began running rough and the pilot started to shut down the engine. The fire warning light went on and the pilot pulled the fire bottle…Incident 20070116831959IPiagio P180 · Eagle, CO(-23) Pilot landed on rwy 25 at Eagle county airport co on January 15, 2007 at 1937 MST, and veered off the runway and collided with terrain during landing. Weather was VFR with a dry runway, but he was on an IFR flight plan, originating in aurora, IL. The…Incident 20070116002519ITmpson NAVION* · El Cajon, CA(-23) Acft had just received a rebuilt engine. An engine runup was performed. An oil leak was observed at the transfer collar area. Four each oil seal rings were replaced. Another engine runup was performed. No problems noted. Pilot took off from runway 27R…Accident 20070116000939ACessna 150A · Cottonwood, AZ(-23) The commercial pilot [privacy data omitted] was making a landing to runway 32 at Cottonwood. There was a moderate left 90 degree crosswind during the landing. The pilot was making a wheel landing and when the tail wheel touched the runway the aircraft…Accident 20070115002229AParten P68C · Adjuntas, Puerto Rico(-23) On January 15, 2007, about 0415 atlantic standard time, a partenavia p 68C, 90KB, registered to and operated by a private individual, collided with trees then a mountain slope near Adjuntas, puerto rico. Visual meteorological conditions prevailed in the…Incident 20070115001719ICessna 402B · Carlsbad, NM(-23) On February 15, 2007 at 0840 MST a Cessna 402B, N593DM, made a hard landing at the Carlsbad, new Mexico (cnm) airport after experiencing an engine failure while on final approach to landing at cnm. The aircraft was operating under 14 CFR 135 on an IFR…Accident 20070115001509ABeech A36 · Caldwell, NJ(-23) N711SK crashed about 3:43NM short of Essex County Airport (cdw) while on the localizer 22 approach. Mda in the vicinity is 860MSL. Terrain in the neighborhood is approximately 400 feet MSL. The aircraft struck the tops of 80 to 100 foot tall trees prior…Incident 20070115000679IEMB ERJ170100SE · Wichita, KS(-23) On January 15, 2007, the flight crew for shuttle america corporation operating as flight 7726, departing denver, Colorado (den) for Kansas, city MO (mci) diverted to Wichita, Kansas (ict) because of a flap slat failure message indication. An aircraft…Incident 20070115000339IPiper PA23250 · Miami, FL(-23) Statement of PIC: my wife and I are the registered owners of N58KM, a 1974 Piper PA23 aztec e. last night, January 15, 2007, I was pilot in command of an international flight that terminated at the customs ramp. Afterwards, around dusk, I repositioned…Incident 20070115000289IBeech 95 · Placerville, CA(-23) On January 15, 2007 the pilot CFI [privacy data omitted] was providing instructional flight in a multi-engine airplane for private pilot [privacy data omitted]. On take-roll roll on runway 23, the pilot CFI ^priva^ pulled the left engine mixture to…Accident 20070114008639APiper PA46500TP · Tampa, FL(-23) On January 14, 2007, at 1825 local time, a Piper PA-46-500TP, registered to clear air aviation LLC, upon landing the engine mount tube broke causing the nose gear to partially collapse after a personal flight. Visual meteorological conditions prevailed…Accident 20070114002259ATmpson Naviong · El Centro, CA(-23) Ucsd hospital interview conducted on 01/18/2007 at 1400 PST. The pilot [privacy data omitted] stated that he topped off the fuel tanks in salinas, CA prior to departure for douthitt airport. He stated that he changed fuel tanks (from the tip tank to the…Accident 20070114001879AN369JG · Titusville, FL(-23) During series of high-speed taxi checks, pilot departed se off rw 15 at Arthur Dunn air park (X21), Titusville, FL. Shortly after takeoff, approximately five seconds into the climb, aircraft lost power momentarily, struk trees at approx. 70 ft AGL, and…Accident 20070114001859ACessna 177 · Carrabelle, FL(-23) This was a VFR flight from pensacola, Florida planned to arrive at clearwater, Florida. Over Carrabelle, Florida at 5500 feet half of one blade separated from the propeller at approximately 50% up the blade. The pilot had a severe vibration and pulled…Incident 20070114000809IBoeing 767432ER · Salt Lake City, UT(-23) The aircraft was taxiing into gate D8 at Salt Lake City International Airport after arriving from honolulu, Hawaii (khnl). There was a delay in parking at the gate due to an improperly parked aircraft at gate D6 immediately adjacent. The crew of dala…Accident 20070114000359ALuscom 8A · El Paso, TX(-23) On January 14, 2007, at 1752 MST, a Luscombe 8A, N1190K, registered to the pilot, ground looped on landing at the El Paso International Airport, El Paso, Texas, while on a personal cross-country flight. Visual meteorological conditions prevailed at the…Incident 20070113001379IPiper PA28180 · Blythe, CA(-23) Student on intial long cross country flight: mesa, AZ (ffz) to Blythe, CA (blh), to williams gateway AZ (iwa) to mesa, AZ. Student lost control of aircraft on landing at blh, struck propeller and right wing tip. Student departed blh in damaged aircraft…Accident 20070113000859APiper PA18 · Tyonek, AK(-23) The pilot, while conducting animal trapping activities, landed in a meadow frequently used by him for such. Shortly after landing, the aircraft became stuck in deep snow. The pilot subsequently snow shoe packed a pad, dug out the airplane, and taxied…Incident 20070113000719IMooney M20C · Zephyrhills, FL(-23) Pilot came to land at kzph and to fit into the traffic flow he executed a wave-off and placed the gear up. As he re-entered the traffic pattern, the pilot failed to re-lower the landing gear thus landed gear up.Incident 20070113000559ICessna 560CESSNA · Reno, NV(-23) N191VF landed rno runway 16L and was instructed by ATC to turn left on taxiway (twy) lima, left on twy charlie and taxi to sierra on frequency. N191VF turned onto the mercury ramp and asked tower how to get to sierra. Tower instructed N191VF to join twy…Accident 20070113000229ACessna 140 · San Jose, CA(-23) The pilot [privacy data omitted] states that at approximately 1700 hours local time, he departed krhv in N18WB for currency practice in the pattern. During his second landing at khrv, he executed a full flap landing on runway 31R. During his attempt to…Incident 20070113000189ISwrngn SA226TC · Laramie, WY(-23) Pilot made an instrument approach to runway 30 at Laramie at 0815 on January 13, 2007. At 17 miles from the airport the aircraft entered VMC and the pilot cancelled IFR and set up for a visual approach to runway 3. UNICOM advised they had just plowed…Incident 20070112007749IMtsbsi MU2B36 · Chicago, IL(-23) Pilot stated that during the circle to 22L, he selected gear down and was reaching for the flap selector when he heard a large bang and saw a flash outside the right side of the airplane. He looked to find the right propeller feathered. He ran the…Incident 20070112007229ICessna 172N · Fergus Falls, MN(-23) Pilot stated that as he started his landing flare a gust of wind blew him off the runway centerline and as the right main gear touched down into the snow along the runway edge it pulled the aircraft to the right and came to an abrupt stop causing minor…Accident 20070112002279ACessna 425 · Harbor Springs, MI(-23) At approximately 1823 EST, on January 12, 2007, the CE-425-425, conquest 1 was destroyed when it crashed during the landing. The aircraft was noted to make a steep approach. At the bottom of the approach the aircraft was also observed to balloon upward…Accident 20070112000949ACessna 525 · North Hills, CA(-23) On January 12, 2007, about 1052 pacific standard time, a Cessna citation jet CE-525, N77215, collided with terrain in van nuys, California. Sun quest executive air charter was operating the airplane under the provisions of 14 CFR part 91. The airline…Incident 20070112000699ICessna 150H · Winthorp, WA(-23) Airman maneuvered aircraft in very close proximity to persons and property on the ground, grossly less than that allowed by FAR 91.119. During completion of low altitude flight aircraft struck powerlines, approximately 30-40 feet AGL, damaging the…Accident 20070112000279ABeech A36 · Farmington, NM(-23) On January 12, 2007, at 1215 MST, N8183E, a Beechcraft BE-36-A36 registered to mesa pilot development incorporated sustained substantial damage upon landing at Four Corners Regional Airport in Farmington, new Mexico. The aircraft was being operated for…Incident 20070112000169ISwrngn SA227AC · Denver, CO(-23) Pilot landed on runway 35L, at Denver International Airport (kden), at 2115L on January 12, 2007. On rollout, pilot turned on nosewheel steering in anticipation of turning off at M6 taxiway, but the aircraft swerved left and pilot was unable to correct…Accident 20070111006999ACessna TR182 · San Diego, CA(-23) The aircraft departed runway 23 and kmyf on an IFR flight plan bound for kcrq. Control tower personnel observed a normal take off and climb out until about 125 feet above the runway. The aircraft then pitched over nose down at about a 65-degree angle.…Incident 20070111006839IPiper PA28R201 · Dayton, OH(-23) The initial report from the FAA inspectors stated that when they were on short final, at wright brothers airport, mgy, the elevator control became jammed when increasing back pressure. The pilot flying, [privacy data omitted], was able to free the…Accident 20070111001309ARobsin R22BETA · Lakeland, FL(-23) While conducting flight instruction in a Robinson R-22 helicopter the instructor performed a slope landing. The instructor stated that the slope was too steep, so he decided to level off and lift off of the surface. Upon liftoff he believed that the…Accident 20070111000269APiper PA18135 · Maricopa, AZ(-23) On January 11, 2007, at approximately 1145 MST, N518GM, a Piper PA-18-135, with the pilot [privacy data omitted] performing as pilot-in-command, ground looped while attempting to land at the university of Arizona ag strip (3AZ2). The pilot [privacy data…Incident 20070111000209IJcb5in Propjet · Helena/West He, AR(-23) On 01/11/2007, 1613 CDT, a home built aircraft Lancair jetprop, N750TL, registered to [privacy data omitted] and piloted by [privacy data omitted] took off from the west Helena airport Arkansas (hee), visual meteorological conditions prevailed. After…Incident 20070110008499ISaab 340B · Eau Claire, WI(-23) At cruise altitude (14000') during flight from cwa to msp, left engine oil low pressure warning illuminated. Oil pressure was below 30 PSI (red line). Crew utilized qrh checklist and secured left engine. Aircraft diverted to eau, during post flight,…Accident 20070110002269ALear 35A · Beaver, OH(-23) On January 10, 2007, the pilot [privacy data omitted], the pilot in command of Learjet 35A, N40AN, operating star-check route 141 from jacksonville, Florida (jax) to rickenbacker international (lck). On descent into rickenbacker at approximately 03:56…