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 20071214827649IAMD FALCON900 · Montrose, CO(-23) On 12/14/2007 at about 11:00 am, N525MH a falcon 900 operated by volo aviation LLC (XORA073U), departed white plains, NY (khpn) for telluride, CO (ktex). While enroute the pilots decided to proceed to their alternate of Montrose, CO (kmtj) due to poor…Accident 20071213831429ABeech E55 · Lancaster, PA(-23) During ILS approach rwy 8 lns, in icing conditions, aircraft impacted soft terrain in a landing attitude, approximately 175 feet short of rwy 8 threshold, near centerline. Impact separated left main and nose landing gears from aircraft. Aircraft slid…Incident 20071212831329IPiper PA44180T · Olathe, KS(-23) The pilot [privacy data omitted] acted as pilot in command of N83628, a Piper PA-44-180T, on a flight under VFR from johnson county executive airport (ojc), Olathe, KS, to New Century Aircenter (ixd), new Century, KS, on 12/12/2008. While landing on…Accident 20071212831259AWootto Aerocanard · Statesville, NC(-23) On 12/12/2007 at approximately 1015 local time, an aero canard aircraft (N199JW sn:0020), piloted by [privacy data omitted], departed runway (rwy) 28 at the Statesville municipal airport (svh). According to witnesses, the canopy of the aircraft opened…Incident 20071212831019IPiper PA28235 · Chicago/Aurora, IL(-23) The pilot [privacy data omitted] moved by hand the propeller of Piper PA-28-235, N3979X, at Aurora Municipal Airport, Aurora, Illinois, at 1242 CST, December 12, 2007 to determine why the starter was not engaging. Nobody was aboard the airplane when the…Incident 20071211828559IPiper PA28R201 · Hollister, CA(-23) The pilot [privacy data omitted], the pilot-in-command and flight instructor, was giving instruction to [privacy data omitted]. [privacy data omitted] Was practicing power-off 180 degree accuracy landings. On this occasion the landing gear auto extend…Incident 20071211828209IEMB EMB145LR · St Louis, MO(-23) Chqa flight 5839 took off from kstl bound for kiah. Durng the climb-out, the flight attendant reported smoke in the lavatory and aft cabin. The smoke produced a "lavatory smoke" eicas message. The crew declared an emergency, returned to kstl, landed on…Accident 20071211827829ABeech A36TC · Minersville, UT(-23) On 12/11/07 at approximately 09:30 MST the aircraft appears to have impacted mountainous terrain while in cruise flight at approximately 7,000 feet MSL approximately 20 miles south of milford, UT. The flight was conducted iaw 14 CFR 91 under VFR rules,…Incident 20071210829059IPiper PA32301 · Togiak Village, AK(-23) N8402S was taxiing to the parking area, when it collided with a parked airplane. The pilot stated he was taxiing to the ramp area at Togiak Alaska when he collided with a parked aircraft. Poor lighting due to the dusk conditions, and the Village agents…Incident 20071210828979IAmtr Glassgoose · San Diego, CA(-23) On December 10, 2007, experimental amateur built glass goose aircraft, N112PG, departed ramona airport on a FAR part 91 pleasure flight. The pilot reported that following departure, N112PG engine began running rough. The pilot successfully completed an…Accident 20071210827979ABeech 200BEECH · Salmon, ID(-23) The aircraft was stored in a heated hangar. Pulled out into minus 06 degree celsius temperatures and heavy snow. The aircraft sat outside for roughly one hour with no deicing. The passengers arrived and were loaded onto the aircraft while the pilot did…Incident 20071210827779IDoug DC983 · Idaho Falls, ID(-23) On Monday December 10, 2007, at 1937Z (1237 mountain time) an allegiant airlines (designator WX0A) Douglas DC-9-83, N883GA, s/n 49710 reported that while executing a landing on runway 20 in Idaho Falls airport (ida) they ran off the runway into snow and…Incident 20071209832339IPiper PA31350 · Gladwin, MI(-23) The pilot back taxied runway 27 for takeoff on runway 27. The runway conditions at the time of the incident was fresh snow on hard pack snow and ice. There was no braking action reported. As the pilot maneuvered the aircraft for takeoff, the pilot made…Incident 20071209831759IPiper PA32R301 · Clewiston, FL(-23) On 12/09/2007 on a VFR flight from fort lauderdale to ocala, the pilot [privacy data omitted] requested an alternate airport because he believed that there was a problem with the manifold pressure and engine oil pressure being low. He diverted to…Accident 20071209829479ABeech H35 · Warrenton, VA(-23) On December 9, 2007, at approximately 2050 EST, a single engine Beech bonanza, model H-35, N5481D, serial number D-4988, registered to the pilot [privacy data omitted], crashed while on the rnav/gps runway 15 approach to the Warrenton-Fauquier Airport,…Incident 20071209829079IBeech B200 · Napa, CA(-23) According to the pilot's written report the aircraft rolled violently to the left during descent. The pilot declared an emergency with ATC and landed the aircraft without incident at Napa County Airport (apc).Accident 20071209828449ACessna 172E · Fair Bluff, NC(-23) He stated that he did find water in the fuel on preflight. He had not flown the aircraft since the annual. He washed the aircraft and sumped it, ran it, and sumped it again. He decided to fly the aircraft and perform a touch and go. He was by himself.…Incident 20071209827759IBeech N35 · West Palm Beac, FL(-23) Right gear collapsed during the rollout after landing. The pilot made three passes at the lantana airport for personnel on the ground to observe if his landing gear was fully down. The personnel on the ground advised the pilot the gear appeared down and…Accident 20071208832209ACessna 172R · Wausau, WI(-23)Pilot was performing landing at auw. After one successful landing and two baulked landings, he touched down more than 1600 feet beyond the approach end of runway 04. The pilot stated it "jerked" as though on a patch of ice. Aircraft turned left and…Accident 20071208829482APiper PA30 · Parkland, FL(-23) Instrument rated private pilot on an IFR flight plan was advised of possible conflicting traffic. Failed to see and avoid.Accident 20071208829469ACessna 152 · Parkland, FL(-23) Student pilot on solo local instructional flight failed to see and avoid a twin comanche.Accident 20071208829269ACessna T210N · Bloomfield, KY(-23) On December 8, 2007, at 1515 eastern standard time, a Cessna T210N, N5431C, registered to a private individual and operated under the provisions of title 14 code of federal regulations (CFR) part 91, collided with the ground in Bloomfield, Kentucky.…Accident 20071208828729ACessna 172G · Hastings, MI(-23) Student pilot on initial solo landed on runway 30. On the second landing he veered off the left side of the runway and the aircraft flipped onto its back causing substantial damage to the fuselage and wings. Runway was dry with small patches of snow and…Accident 20071208828179ACessna 182C · Spokane, WA(-23) On December 10, 2007 N9048T, a 1960 Cessna 182 received substantial damage after crashing through the Felts Field, Washington airport chain link perimeter fence. N9048T was configured as a parachute jump airplane with only one seat and a jump door…Incident 20071207831889IPiper PA32R301 · West Palm Beac, FL(-23) When landing at west Palm Beach airport (pbi) Florida, the landing gear did not extend. Cycled the gear and gear light did not indicate down. The circuit breaker was popped. The pilot activated the emergency gear extension and landed the aircraft. The…Incident 20071207831879IPiper PA28161 · Venice, FL(-23) On December 07, 2007, at 10:38 EST, a Piper, N9221D, operated by the pilot [privacy data omitted] sustained minor damage at the Venice Municipal Airport (vnc), Venice, Florida. This was a FAR 141 flight school cross country flight that originated at…Incident 20071207829209IPiper PA18 · Monroe, LA(-23) Pilot was taxiing and was about to enter closed taxiway. Controller told the pilot to "stop"! Pilot applied too much brake and aircraft went onto nose.Accident 20071207828389APiagio P180 · Battle Mountai, NV(-23) VOR DME approach to runway 03 was initiated. Aircraft broke out at approximately 750' AGL and made a normal touchdown. Winds were 330 degrees at 5 knots. Runway was wet with no standing water. Pilot engaged nose wheel steering somewhere just below 60…Incident 20071207828229ICessna 402C · Fort Lauderdal, FL(-23) During block-out while turning left from the parking spot at the fix based operator's (sheltair) ramp, the right propeller struck a traffic cone damaging the right side of the fuselage skin and right nose landing gear door.Incident 20071206832289IPiper PA23250 · Fort Myers, FL(-23) On December 6, 2007, at 13:21Z, a Piper PA-23-250, N68SE, registered [privacy data omitted], rolled into a berm at the Page Field Airport, ft. Myers, FL. The aircraft received minor damage to the nose gear and the pilot on board was not injured.Accident 20071206829089ASenfta C5 · Oro Valley, AZ(-23) Aircraft was on its 23rd hour of phase 1 flight time under a special airworthiness certificate issued 10-12-2007. The aircraft left marana regional airport and began climbing east towards la cholla airpark. At approximately 5500 ft the engine power was…Accident 20071206828889APiper PA28180 · Fallbrook, CA(-23) The pilot [privacy data omitted] was practicing short field touch and go landings at Fallbrook airport (L18), at approximately 1600 hours pacific standard time. He was established in a left traffic pattern set up for runway 18. There was a frontal…Accident 20071206828499AAirtrc AT401 · King City, CA(-23) The pilot [privacy data omitted] stated he was starting his second pass of the aerial application flight, when he became distracted setting up his "GPS unit for swath guidance." He stated he looked up and suddenly found himself in a box canyon with…Accident 20071206827859APiper PA28236 · Orting, WA(-23) On 12-6-2007 at about 1800 local time the aircraft departed S36 (crest airpark) enroute to plu (thun field) and was subsequently reported missing on 12-09-2007. The weather at plu on 12-06-07 at about 1810 was reported to be broken overcast with a…Accident 20071205832469APiper PA28R200 · Augusta, GA(-23) At approximately 2230Z pilot contacted Augusta tower to report a rough running engine and request the location of the nearest airport. During descent to 2000 feet the pilot reported that the engine had quit and that he would attempt to land on a road or…Incident 20071205831779ICessna 172P · Fort Pierce, FL(-23) On December 5, 2007, at 1150 eastern daylight time, a Cessna, CE-172, N65276, experienced the loss of operational control during taxiing, at kfpr, in Fort Pierce, Florida. As a result of the loss of control the aircraft taxied into the grass impacting a…Incident 20071205831729IWheele Wheelerfour · Mobile, AL(-23) Aircraft N3XD landed on runway 32 at bfm. During landing rollout, nose wheel collapsed. Aircraft stopped on right side of runway 32, approximately 2,300 from landing threshold. Pilot egressed aircraft with no injuries. Damage was to propeller and bottom…Accident 20071205828759ACessna 208B · Columbus, OH(-23) On December 5, 2007 at approximately 0651 (local time), N28MG, a Cessna caravan 208B, operated by castle aviation under 14 CFR part 135 impacted the ground shortly after takeoff from runway 23R at klck (Rickenbacker International Airport). Instrument…Accident 20071205828469ABell UH1B · Ennis, MT(-23) On December 5, 2007, at 1600 mountain time, a garlick UH-1B, N46969, registered to r & r conner aviation LLC, made a hard landing at the helicopter logging service landing area in madison county, Montana, 33 nautical miles sw of Ennis, Montana, while…Incident 20071205827659IPiper PA28160 · Berryville, AR(-23) On December 5, 2007, at 1030 central daylight savings time, a Piper PA-28-160 received minor damage during a normal landing at Carroll County Airport, Berryville Arkansas when a turkey impacted the passenger windshield and ended up inside the aircraft.…Accident 20071204828719ABeech 60 · Wilmington, DE(-23) Based on eyewitness reports, N105PP departed New Castle county airport, New Castle, DE (kilg) on runway 27. At approximately 200 feet the aircraft began a left roll, climbed to about 300 feet and then continued a left roll until it struck the ground in…Incident 20071204828639IRobsin R22BETA · Fresno, CA(-23) During an instructional helicopter flight, which involved completing three (3) autorotations, the pilot depressed the pedal assembly while on the ground and felt and heard a loud "snapping" noise. Further examination revealed that the support bracket…Incident 20071204826839ICessna 402C · Nantucket, MA(-23) Nose gear collapsed on landing at ack rwy 33, 0702 EST, no passengers, mail flight, no injuries. Damage to props and fuselage, pilot had 3 green on landing.Incident 20071203831639IPiper PA34200T · Athens, TX(-23) On 3 December 2007 at or about 1710L the PA-34-200T serial number 34-8070212, registered as N8195Z, landed gear up at the Athens, Texas airport (F44). The pilot reported that he was out flying for night currency. The second landing of the night he…Incident 20071203831009IAmrgen AA5B(-23) 11/30/07-N3750Z said he was experiencing electric failure and needed to divert to laf. Chicago ARTCC coordinated a visual approach. N3750Z landed laf. Laf twr confirmed at 1942Z.Incident 20071203829369IDhav DHC8102 · Pittsburgh, PA(-23) After take-off from 28C, the left main landing gear door open light remained illuminated after gear retraction. The landing gear was then extended to down-and-locked, and the aircraft returned to the airport for a normal landing on runway 28L.…Incident 20071203829339ISaab 340B · Pittsburgh, PA(-23) After take-off from 28C, the landing gear would not retract. The landing gear was then extended to down and locked and the aircraft returned to the airport for a normal landing on 28L. Investigation by jet car (412-812-3276) found ice accumulation on…Accident 20071203828419AUrocop BK117C1EURO · Whittier, AK(-23)On 12/8/2007, the crew of an Alaska air national guard pave hawk helicopter found aircraft wreckage and human remains that washed up on the north shore of passage canal, which leads into Whittier, Alaska. The air ambulance helicopter, operated by…Accident 20071203827059AAmtr RV6A · Stringer, MS(-23) During cruise at 5500 feet engine shutdown. Pilot made emergency landing in grass field. Aircraft nose gear collapsed and aircraft flipped over.Accident 20071202828479ACessna 551 · Coeur D'Alene, ID(-23) N551GF was cleared for the ILS runway 5 at coe. Upon acceptance of the clearance N551GF advised that he would be circling for runway 23 at coe. The pilot in command reported that upon touchdown the aircraft began to hydroplane. The PIC attempted to…