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 20061217026409ICessna TR182 · Perry, OK(-23) On December 17, 2006 @ 1630Z N182E a CE-182RG landed gear up on runway 35 at the Perry Municipal Airport. In a telephone interview with an operations inspector at the Oklahoma city FSDO, the pilot in command stated that he simply forgot to extend the…Accident 20061217026059ACessna 172L · Bonners Ferry, ID(-23) On 12-17-2006 at approximately 1045 hours, while attempting a take-off on runway 20 at the boundry county Idaho airport (65S), the student pilot and sole occupant of the aircraft, a CE-172-L lost control of the aircraft. At the time of this attempted…Incident 20061217025799IEMB EMB120ER · Sacramento, CA(-23) Skywest flight 5709, departed smf, shortly after takeoff they struck a bird on the left engine. The flight returned to the field. Damage was to the left engine inlet cowl.Incident 20061217025719IAmtr DR107 · Siler City, NC(-23) Airman was performing maneuvers in an aircraft type that he had not previously flown and was being given instructions by radio. Pilot failed to maintain airspeed, aircraft stalled. Contacted the ground about 95 feet short of the approach end of runway…Incident 20061216030349IPiper PA34220T · Patterson, LA(-23) Airman failed to extend landing gear per "before landing" checklist. Pilot mistook gear warning horn (audible alarm) for a non-existent GPS waypoint crossing alarm. He was unable to initiate a go-around prior to ground contact and terminated the landing…Incident 20061216030219IBeech J35 · New Hudson, MI(-23) Aircraft N8388D gear up landing at oakland - sw airport.Incident 20061216030189ICessna 172H · Sparta, MI(-23) Pilot lost control in a crosswind.Accident 20061216029079ABlanca 1730A · Jay, OK(-23) Non certificated pilot took three passengers out for a joy ride around grand lake. Pilot admitted to first responders that he had a couple of margaritas before the flight. Witnesses reported the aircraft flying in a southerly direction low over the…Incident 20061216026139IMichae IVP · Redmond, OR(-23) Aircraft is experimental pressurized Lancair iv-p built in 2004 and flown by owner. At 23,000 feet enroute to khnd pilot's side window fractured and blew out of door causing immediate depressurization of aircraft. Pilot declared an emergency and landed…Incident 20061215030249IPiper PA46310P · Dayton, OH(-23) Aircraft experienced a partial power loss and a precautionary landing was made at day.Incident 20061215027759IPiper PA34200T · Tucson, AZ(-23) During an instructional flight on a 2 mile downwind, the forward baggage door broke in two and and one part departed the aircraft. Aircraft landed without further incident. No secondary damage noted to the aircraft. The part of baggage door that…Accident 20061215027489AAmtr Aventuraii · Palmbeachgarden, FL(-23) On Friday 15 December 2006 at approximately 1300 hours eastern daylight standard time an amphibious adventura ii, registration number N554FS, serial number AP2A0031, attempted a water take-off of the intracoastal waterway. The aircraft was certificated…Incident 20061215027349IAyres S2RT34NORMAL · Wheeler Ridge, CA(-23) On 12/15/2006, at approximately 1130 PST, Ayres S2R thrush aircraft, N4002S, collided with an automobile on the ramp of the Wheeler Ridge strip (no identifier). The pilot, [privacy data omitted] pilot in command of N4002S, operating under 14 CFR 137,…Accident 20061215026919ACessna 421B · Brackettville, TX(-23) On December 15, 2006, at approximately 2132 CST, a Cessna CE-421B, N642CB, was destroyed after the pilot made an approach to a 5300 foot paved, lighted ranch strip. The pilot said some of the runway lights were out and he was confused as to what side of…Incident 20061215026449IPiper PA28R200 · San Antonio, TX(-23) On December 15, 2006, at approximately 2000 CST, a Piper PA-28R-200, N4977S, sustained minor damage when the nose gear did not come down as the pilot was performing take-offs and landings at Stinson Municipal Airport in San Antonio, Texas. The private…Accident 20061214031329ASchler ASK13 · Gregory, MI(-23) On Thursday, December 14, 2006 at approximately 13:00 EST, N545TT, a schleicher AS-K13 glider took off in tow from Richmond Field (69G), runway 18, in Gregory Michigan, with the pilot [privacy data omitted] the pilot in command (PIC) in the back seat…Accident 20061214030829ABeech B36TC · Peoria, IL(-23) N30799 experienced a loss of engine power and smoke in the cockpit during cruise flight, and was subsequently destroyed by fire after a forced landing to a field about 1.5 miles west of the greater Peoria regional airport (pia), Peoria, Illinois. The 14…Accident 20061214029249ACessna 172C · Middletown, NY(-23) On December 14, 2006, at approximately 1600 EST, the subject aircraft was being repositioned from greenwood lake airport (4N1), west milford, NJ to Randall Airport (06N), Middletown, NY for the purpose of having the annual inspection performed. The…Accident 20061214029239ACessna 310Q · Montgomery, NY(-23) On December 14, 2006 at approximately 1310 EST, the subject aircraft departed runway 26 at kmgj, climbed to between 200 and 500 feet AGL and leveled off. The aircraft began porpoising, turned left while descending and impacted trees approximately one…Incident 20061214029119IAmtr LC41550FG · Van Nuys, CA(-23) While on approach the aircraft was about 10 KTS high. The aircraft touched down after the numbers on 16L. On landing the aircraft bounced once causing the wheel pant assemblies on both main gears to break off the aircraft. As the wheel pant assemblies…Accident 20061214027569APiper PA32301 · Port Heiden, AK(-23) Penair flight 842 left Port Heiden approx 18:05 enroute to king salmon, Alaska (akn). Flight was originally scheduled to depart around 14:30. Reports indicate takeoff was after dark. Pilot called company to report departure shortly after take off.…Incident 20061214026329IHughes 369E · Fresno, CA(-23) N922SD was conducting law enforcement operations as a public use aircraft at 500 feet AGL and 60 KIAS when a seagull shattered the upper right wind screen, striking the observer in the face. The pilot and observer were wearing flight helmets with the…Accident 20061214025959ABell 407 · Dagsboro, DE(-23) On December 14, 2006, at approximately 18:06 local, N407JJ flown by pilot-in-command [privacy data omitted] crashed shortly after takeoff. The pilot [privacy data omitted] held a commercial pilot certificate with a rotorcraft-helicopter rating. At the…Incident 20061214025809IIsrael 1124 · Sarasota-Braden, FL(-23) On December 14, 2006 at 2115 EDT, a west wind model 24, N298HM, registered to jfb aircraft westwind inc. landed at Sarasota-Bradenton International Airport (srq) on runway 14 and blew the left main tire. The aircraft exited the runway into the grass…Incident 20061213029999IRaythn C90GT · Kenosha, WI(-23) At Kenosha airport (kenw) at approximately 23:00 local on December 13th, king air N106ML departed the left side end of runway 6L at approximately 70 KTS. Upon exiting the runway the aircraft struck a runway light with the right propeller. The aircraft…Accident 20061213029679AAerors J2 · Williamson, GA(-23) Inspector statement: I was contacted by my supervisor/faa communications center on December 13, 2006, and was assigned to an accident that had occurred in the vicinity of Williamson, Georgia, where a Piper J-2 airplane had crashed while attempting to…Accident 20061213028842APiper PA28161 · Naples, FL(-23) On 12/13/06 at Naples airport, Florida (apf) private pilot [privacy data omitted] was taxiing a pitts single place aerobatic tail wheel aircraft N427RD south on taxiway a for departure on runway 5. Pilot of pitts struck right wing tip area of Piper…Accident 20061213028589APiper PA31T1 · Waterloo, IA(-23) VOR approach to runway 18 at the Waterloo Municipal Airport, Waterloo, Iowa. Pilot reported visual approach 2 to 3 miles from end of runway. Pilot reported he increased power prior to touchdown. This veered him to the right. Aircraft impacted ground.Incident 20061213027159ICessna T210M · Mound City, KS(-23) On 12/13/2006 approx 1500 hrs local the pilot departed from johnson county executive airport (ojc) destined to the Kansas city downtown airport (mkc). 1 passenger boarded the aircraft and they departed for the fort scott, KS. Area at 1530. When the…Incident 20061212030079IPiper PA31350 · Great Bend, KS(-23) The pilot [privacy data omitted] stated: he departed IFR from atw enroute to gbd, the entire operation was normal until touchdown on runway 33. The runway was covered with black-ice which was not detectable until the aircraft was on the runway. As the…Accident 20061212028779ARhnflu EA300L · Boulder City, NV(-23) Sequence: the accident aircraft was operating as the second aircraft in a flight of two. The purpose of the flight was formation practice. The wind had been reported earlier as 030-060 at 6 gusting to 14 knots. The lead aircraft was airborne on the…Accident 20061212028629APiper PA28140 · Brandon, OR(-23) The aircraft (N5618U) flown by the pilot [privacy data omitted] took off from the bandon State airport at approximately 1220L and crashed at 1248L. The aircraft was observed at tree-top level on the downwind leg of the traffic pattern at bandon State…Incident 20061212027139IBeech 95B55 · Grants, NM(-23) On December 12, 2006, at approximately 2000 MST, a take-off roll was initiated on runway 13 at gnt in N66X, a Beechcraft model 55 baron, serial number TC-773. At about 900 feet down the runway, the aircraft veered to the left and ran off the runway, the…Incident 20061212025879ICessna TR182 · Knoxville, TN(-23) The pilot, unable to fully extend the landing gear, landed on the grass to the left of the pavement off runway 8. The aircraft rolled/slid to a stop on the nose gear and belly. At the very end of the roll/slide the left wingtip and left horizontal…Incident 20061212025129ICessna 180J · Little Rock, AR(-23) On December 12, 2006, at 1540 CST, N180RN, a Cessna CE-180 skywagon, ground-looped and nosed over after landing. The pilot stated that he experienced a 'vortex' that suddenly turned the airplane to the right. In an effort to prevent going off the runway…Incident 20061211029739IPiper PA30 · Tavernier, FL(-23) Aircraft sustained damage during a hard landing at Tavernaero airport in Tavernier, FL. [privacy data omitted]Accident 20061211029309ATmpson Naviong · Coalton, OH(-23) On December 11, 2006, at approximately 1400 EST, a navion g, N33FL, registered to and flown by the pilot [privacy data omitted] had the nose and left main gear collapse on landing at Baisden Airport in Coalton, Ohio. Visual meteorological conditions…Accident 20061211028799AHughes 269B · Houma, LA(-23) N9396F was on local training flight for helicopter CFI rating. Student pilot at the controls on climbout when aircraft experienced a shudder at approximately 400 feet. Student transferred controls to instructor and instructor began a crosswind turn. At…Accident 20061211028169APiper PA28151 · Danbury, CT(-23) As stated by the student pilot and the CFI observing the student pilot's first solo flight attempt on 12/11/2006. At approximately 14:00 hours the pilot [privacy data omitted] taxied to the control tower to let [privacy data omitted] (CFI) out of the…Incident 20061211027109IAmtr Europaxs · Mesa, AZ(-23) The flight originated at Falcon field, the total length of the flight was 1.9 hours. Runway 22L was the landing runway, the wind was called out as variable at 155. The approach to landing was normal, the aircraft touched down with a slight bounce, the…Incident 20061211026339IDoug DC931 · Omaha, NE(-23) N9338, DC-9-31, was operated by northwest airlines, inc. as flight 1723 from detroit, MI, to Omaha, NE. The pilot executed a go around because of a gear problem on final approach. The pilot reported that he had an indicator light indicating that the…Incident 20061211026219IBeech B36TC · Houston, TX(-23) N66532, a BE-36-B36TC departed Houston's Hobby (hou) airport at approximately 1247 CST on an IFR flight plan to mid-way regional airport (jwy) near waxahachie, Texas. The pilot received three separate weather briefings from the montgomery county afss at…Incident 20061211026119IBell 407 · Raytown, MO(-23) On December 11, 2006, at 2217 CST, a Bell 407, N302LE, operated by cj systems aviation group (dba life flight eagle) as an air ambulance, executed an emergency landing on a school parking lot near Raytown, Missouri. Pilot stated that during cruise…Accident 20061211025919ACessna 172RG · Laurel, MT(-23) Changing crosswind upon landing caused a loss of control. Aircraft departed runway and flipped over forward.Incident 20061210030319IPiper PA23250 · Fremont, OH(-23) On approach, an extension of the flaps was initiated with no result (zero degrees) in flap travel. Suspecting a problem with the hydraulic system, the pilot [privacy data omitted] attempted to extend the main landing gear, which resulted in no action,…Accident 20061210030289ABombdr BD1001A10 · Chicago/Waukeg, IL(-23) N523FX struck a flock of birds on climb-out from Waukegan airport (kugn), Waukegan, Illinois. The pilot did not declare an emergency and there was no reported aircraft damage. This office was informed months later, that the aircraft returned to kugn…Incident 20061210030229ISocata TB20TRINIDAD · Indianapolis, IN(-23) On 12/10/2006, trinidad N112A was landed with the landing gear in the retracted position, on runway 18, at Indianapolis executive airport, at night in VFR conditions, on a dry runway. The pilot forgot to ensure that the landing gear were correctly…Incident 20061210029929IPiper PA28151 · Dayton, OH(-23) On 12/10/2006 while operating his Piper warrior, N9152K, the pilot [privacy data omitted] and a passenger departed from shelbyville, in (gez) and flew to connersville, in (cev) where they landed for a brief amount of time. They then departed cev and…Accident 20061210029489AHigher Superhornet · Chandler, AR(-23) The following crash occurred on December 10, 2006 at 0952 MST. The experimental aircraft, N45YB, s/n 060 manufactured by Higher class aviation, a super hornet, crashed shortly after takeoff from Chandler municipal airport. The pilot [privacy data…Accident 20061210028819AAmtr RANSS6S · Taylorsville, NC(-23) On December 10, 2006 at approximately 1520 hours local time, a private pilot and his non rated passenger were making a low pass down runway 09 at about 100 feet above the ground. The airplane was observed in a slow steady climb over trees on the…